Need help on total time calculation

Microsoft Excel 2002 (version upgrade)
April 22, 2010 at 11:03:55
Specs: Windows XP
Have a time sheet 3 columns: start time, end time, total time, need formula for 3rd column down on total time. can you assist me?

See More: Need help on total time calculation

April 22, 2010 at 11:19:13
Have you tried this?

Start time in A1
End TIme in B1
Total time in C1: =B1 - A1

Report •

April 22, 2010 at 11:27:08

If the start and finish times sometimes cross midnight use the following formula:


This adds 1 to the finish time when the finish time is 'earlier' than the start time, because the finish time is in the next day.

(In Excel time, 1 is equivalent to 24 hours)


Report •
Related Solutions

Ask Question