Colt,

With 22:00 in A1 and 02:00 in B1, try:

=B1-A1+(A1B1)

or if you want the answer in real numbers:

=(B1-A1+(A1B1))*24

and format the cell as General or Number

An alternative would be:

=MOD(B1-A1,1) for time

or

=MOD(B1-A1,1)*24

for a General number


--
HTH

Sandy

Replace@mailinator with @tiscali.co.uk
"colt" wrote in message
...

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


--
colt