Date Diff

S

Stan

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!
 
C

Chip Pearson

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
 
S

Stan

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?
 
Top