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

Report •


#1
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 •

#2
April 22, 2010 at 11:27:08
Hi

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

=IF(B1<A1,B1+1-A1,B1-A1)

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)

Regards


Report •

Related Solutions


Ask Question