Stan,

Times are stored as a fraction of a 24-hour day (6:00 = 0.25,
12:00 = 0.5, 18:00 = 0.75, etc). Thus, you can subtract the start
time from the end time as normal subtraction.

=end_time - start_time

Format the result cell as time.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"Stan" wrote in message
...
I need to calculate the difference between two time fields that
are formatted
to 'Medium Time'. For example: start time = 12:55 pm end
time = 1:57 pm

I hoping to return it in an 'hh:mm' format. The above example
would return
1:02.

Any help you can provide would be most appreciated.

Many thanks!