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