Discussion Locked

calculate number of hours

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Is there an Excel formula I can use to calculate the number of hours that elapsed given a start date and time and an end date and time?

5 replies

by mark

This formula will give you the difference in minutes between two dates. Make sure the cells containing the dates are formatted as date & time.

=1440*(A1-A2)

To calculate in hours / 60.

Good luck!

This discussion is closed to new replies.