Date Diff
 

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!

Date Diff
 

Well I forgot to mention I was doing this in Access. When I subtract the end
time from the start time I get 23:28 as a result. I'm using 12:55 pm as the
start time and 1:27 pm as the end time. Any thoughts on what I did wrong?



"Chip Pearson" wrote:

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!