time passedd

Question

Level 2

255 points

time passedd

ok i want to do my roster on numbers so i put start time in one row then fin time in next row i want the 3rd row to add the time i have been at work that day (this i will do for the whole week then have the total hours worked in that week at the end) but it i cant get it to calculate 13:00 to 18:00 is 5 hours i have to do this manually. is there any way i kin get numbers to do this for me?

thanks in advance

eMac 1.42, Blackbook 2ghz c2d, imac 24''2.8 extreme, Mac OS X (10.5), iPhone 16gig, 2 60gig ipods, photo white+vid black 500gig minimax hdd

Posted on May 14, 2009 11:38 AM

Reply

Answer 1

Best reply

Badunit

Level 7

26,158 points

May 14, 2009 11:48 AM in response to paton

This should be an easy subtraction operation.

Enter 13:00 into cell B2. It displays as 1PM if the cell format is "automatic"
Enter 18:00 into cell B3. It displays as 6PM if the cell format is "automatic"
Put =B3-B2 into cell B4. It calculates it to be 5 hrs.

If you work past midnight, you will have to enter the date along with the time in cells B2 and B3.

Reply

Answer 2

paton Author

Level 2

255 points

May 15, 2009 2:02 PM in response to Badunit

ta i got it...

Reply

Answer 3

billoz

Level 1

0 points

Jul 23, 2009 1:25 AM in response to paton

OK - same idea, but a different question
I have three start and finish times, the subtraction of which gives a duration in hrs mins. If I add the three durations, the result is a number, with a blue tag "duration units removed'.

Obviously, it should be a duration too, and I can't see why it isn't, attempts to change the format to duration do not work.

Appreciate any assistance.

Reply

Answer 4

KOENIG Yvan

Level 8

41,807 points

Jul 23, 2009 2:20 AM in response to billoz

Surprizing behavior.

here it behaves flawlessly.

Yvan KOENIG (from FRANCE jeudi 23 juillet 2009 11:20:31)

Reply

Answer 5

Badunit

Level 7

26,158 points

Jul 23, 2009 6:58 AM in response to billoz

Look again at what you are adding. If any of the values in your addition/sum are not a duration, you will get the result you are seeing. From your post it would appear that you are summing durations but perhaps there is a mistake?

Reply