General discussion

Locked

calculate number of hours

By Sapinto ·
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?

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by mark In reply to calculate number of hours

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!

Collapse -

by Sapinto In reply to

Poster rated this answer.

Collapse -

by DKlippert In reply to calculate number of hours
Collapse -

by chitosunday In reply to calculate number of hours

Just subtract the date finished by the date started then format the cell as [hh]

Collapse -

by Sapinto In reply to calculate number of hours

This question was closed by the author

Back to Software Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums