colt Wrote:
I am trying to get this result in excel


22:00 to 02:00 =4

22:00 to 03:30 = 5.5

Can anyone help me with this please

Thanks in advance
If 22:00 is in A1 and 2:00 is in B1 then this would work if you format
the cell it is in to a Time format of hh:mm:

=IF(A1B1,B1-A1+24,B1-A1)


--
jahoobob