ExcelBanter - How to calculate time difference in hrs

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - How to calculate time difference in hrs (https://www.excelbanter.com/excel-programming/420227-how-calculate-time-difference-hrs.html)

Will

How to calculate time difference in hrs

Dear All,

which functions shd i use to calculate the time difference between or with
ref. to 2 dates

i.e: 23/Nov 2300hrs - 25/Nov 0100hrs = 26hrs (result I want)

Mike

How to calculate time difference in hrs

A1 = 23/Nov 2300hrs
B1 = 25/Nov 0100hrs
C1 = Formula =(A1-B1)*24

"Will" wrote:

Dear All,

which functions shd i use to calculate the time difference between or with
ref. to 2 dates

i.e: 23/Nov 2300hrs - 25/Nov 0100hrs = 26hrs (result I want)

All times are GMT +1. The time now is 12:55 PM.