Time Differences over a day

[originalmedic]

Hi All,

I've tried to do some formulas to calculate time differences between two times. My problem comes when the times go over to the next day it doesn't calculate or says an incorrect time. Can someone advise? Attached image

I am trying to find out the difference between 06:02pm and 10:36am the next day

 

[Fluff]

That format is wrong, it will not show the minutes.

 

[awoohaw]

column E formatted as [hh]:mm :

mr excel questions 27.xlsm
	A	B	C	D	E
1	start date	start time	end date	end time	hours elapsed
2	2023-03-23	18:02	2023-03-24	10:36	16:34
3	2023-03-23	18:02	2023-03-26	10:36	64:34
samlea

Cell Formulas
Range	Formula
E2:E3	E2	=(C2+D2)-(A2+B2)

 

[awoohaw]

That format is wrong, it will not show the minutes.

yes, had typo ss insteadd of mm! oops.