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