Formula to find the time difference between two dates and times

[pratheesh1983]

looking for a formula that helps find the number of hours between two dates and a time value. I used a formula (=HOUR(G3-F3) & ":" & MINUTE(G3-F3)), but in some cases it's showing some errors coming value as "#VALUE!". Can you please help if the formula which I'm using is correct?

F	G	Hours Difference (formula column)
08/09/2023 22:21:46	09/09/2023 10:16:51	11:55
05/09/2023 23:46:24	06/09/2023 06:27:54
22/09/2023 20:38:25	24/09/2023 07:51:06

 

[etaf]

you should just be able to take F away from G and then format the cells to
[H]:MM

the [] makes the cell show over 24hrs

Book8
	F	G	H	I
1
2
3	F	G	Hours Difference (formula column)
4	9/8/23 22:21	9/9/23 10:16	11:55
5	9/5/23 23:46	9/6/23 6:27	6:41
6	9/22/23 20:38	9/24/23 7:51	35:12
Sheet1

Cell Formulas
Range	Formula
H4:H6	H4	=G4-F4