TIME

S

Saru

Can you please advice me how to add a block of time for a weekly timesheet?
I tried sum function; =sum(a3:a6)*24. But I couldn't get the correct answer.
Ex :
Time in out total
10:30 17:30 7
09:25 18:50 9.25
06:15 20:45 14.30
Total = 7+9.25+14.30 = 30.55 (I want to know the function for this step)
Thank You
 
N

Niek Otten

Format the result to avoid tipping over at 24H:

Format>Cells>Number tab, Custom, in the Type box, enter [h]:mm
 
W

wjohnson

Here is how to make it work:
Results:

A B C
10:30 17:30 7:00:00
9:25 18:50 9:25:00
6:15 20:45 14:30:00
30:55:00

In column C: go to FORMAT - CELLS - TIME - Then select the time which
shows HH:MM:SS and it should work - then just select SUM for the
results in Row 4 (30:55). Column C is just =B1-A1.
 
S

Sue Hughes

THAT was the best solution out there!

Niek Otten said:
Format the result to avoid tipping over at 24H:

Format>Cells>Number tab, Custom, in the Type box, enter [h]:mm

--
Kind regards,

Niek Otten

Saru said:
Can you please advice me how to add a block of time for a weekly
timesheet?
I tried sum function; =sum(a3:a6)*24. But I couldn't get the correct
answer.
Ex :
Time in out total
10:30 17:30 7
09:25 18:50 9.25
06:15 20:45 14.30
Total = 7+9.25+14.30 = 30.55 (I want to know the function for this step)
Thank You
Click to expand...
Click to expand...
 
Top