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

Format the result to avoid tipping over at 24H:

FormatCellsNumber tab, Custom, in the Type box, enter [h]:mm

--
Kind regards,

Niek Otten

"Saru" wrote in message
...
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

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.


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640
View this thread: http://www.excelforum.com/showthread...hreadid=497896

THAT was the best solution out there!

"Niek Otten" wrote:

Format the result to avoid tipping over at 24H:

FormatCellsNumber tab, Custom, in the Type box, enter [h]:mm

--
Kind regards,

Niek Otten

"Saru" wrote in message
...
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