Thank you Bob for taking the time to help me out. I couldn't get this
formula working, but appreciate the assistance.
--
Carla


"Bob Phillips" wrote:

Try this

=MOD(TEXT(--(B1),"00\:00")-TEXT(--(A1),"00\:00"),1)

--
__________________________________
HTH

Bob

"Carla" wrote in message
...
Hello,
Using Excel 2003, I am trying to convert 24 hour times (currently
formatted
as general) into h:mm AM/PM. My ultimate goal is calculate the difference
between times, which sometimes straddles two 24 hour periods. See example
data and current formatting below.
Hope someone can help.
Thanks,
--
Carla

Arrival time Departure time Difference
2335 0250
1340
0200
1400
0240
1355
0130
1300
0220
1435
0245
0730