Computers and Technology, 02.12.2019 18:31 coolfreekid3

Raul is setting up an excel spreadsheet to track how many hours his employees work each day. for the first worker, he has inserted the formula "=(i3-h3)” into cell j3.

raul needs to see a number of hours but instead he sees a decimal. he knows the employee worked more than 0.35 hours that day. what should raul do to make j3 show a number of hours?

a. insert “*24” at the end of the formula

b. reformat j3 as a general number

c. insert “hours” after the equal sign in the formula

d. change the order of the cells referenced in the formula

Raul is setting up an excel spreadsheet to track how many hours his employees work each day. for the

Answers: 1

Show answers

Answers

Answer from: thevampsrock3

The key to solve this number time format in Excel lies in understanding the simple seconds, hour and day calculations together with cell referencing. Cell referencing stands for the cell names where we will be performing our formula.

Explanation:

Numbers in Excel comes in various format. One of the headache from it is Excel often recognize times (x) as a decimal even when we are talking about time or hour. The key to solve this number time format in Excel lies in understanding the simple seconds, hour and day calculations together with cell referencing. Cell referencing stands for the cell names where we will be performing our formula.

The formula that we need to put in to cell J3 should have an idea like this: = (Clocked out - Clocked in) x 24

You can just use a simple formula by applying subtraction operation using from your clocked out / time out to your clocked in / time in. The answer will be the difference of this two times then you should multiple it to 24 which stands for 24 hours in one day.

Another thing, you must use the INT function to make sure that our answers in excel will be rounded off to the nearest integer. We definitely don't want any decimals in any of our cells.

Therefore the formula should look like this in cell J3: = INT((I3-H3) *24).

Almost a similar idea can be applied if we want to solve for the MINUTES between two times. Instead of using 24, we must use 1440 instead. Now, why do we need to use 1440? 1440 stands for the total minutes that we have for a single day. (24 hours * 60 minutes = 1440 minutes)

Therefore the formula should look like this: = ((I3-H3)*1440).

Answer from: Quest

sorry i dont know what you mean by this problem : c

Answer from: Quest

no, it just either gets automatically 5 points to give away, or u can choose how many points u want to give but, the answerer only gets half

Another question on Computers and Technology

Computers and Technology, 22.06.2019 18:30

Technician a says that a shop towel should never be used to clean around the flange area before replacing an automatic transmission filter. technician b says that a dimpled transmission fluid pan can be repaired. who is right

Answers: 3

Answer

Computers and Technology, 23.06.2019 13:30

Select the correct answer from each drop-down menu. which types of computer networks are bigger as well as smaller than a man? a man is a network of computers that covers an area bigger than a , but smaller than a .

Answers: 1

Answer

Computers and Technology, 23.06.2019 21:00

Which set of steps will organize the data to only show foods with more than 100 calories and rank their sugar content from greatest to least?

Answers: 1

Answer

Computers and Technology, 24.06.2019 04:30

How do you share someone else’s tweet with your own twitter followers?

Answers: 1

Answer

You know the right answer?

Raul is setting up an excel spreadsheet to track how many hours his employees work each day. for the...