Microsoft Excel 2002 (version upgrade)

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?

Have you tried this? Start time in A1

End TIme in B1

Total time in C1: =B1 - A1

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

Ask Your Question

Weekly Poll

Do you think another person will land on the Moon by 2024?

Discuss in The Lounge

Poll History