ExcelBanter - Date/time Duration

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Date/time Duration (https://www.excelbanter.com/excel-worksheet-functions/27449-date-time-duration.html)

zjay

Date/time Duration

How do I make a formula in excel which will allow me to calculate the
duration in hours and minutes of two different dates and times? IE: 1/1/05
01:00 to 1/2/05 01:00 is 24 hours and 0 minutes.

Bob Phillips

Just subtract the lesser from the larger and format as [hh]:mm

--
HTH

Bob Phillips

"zjay" wrote in message
...
How do I make a formula in excel which will allow me to calculate the
duration in hours and minutes of two different dates and times? IE:
1/1/05
01:00 to 1/2/05 01:00 is 24 hours and 0 minutes.

All times are GMT +1. The time now is 06:38 AM.