Date-Time Calculations

  • Thread starter Thread starter April Durett
  • Start date Start date
A

April Durett

I am able to subtract dates and subtract times; however, I
want to combine the two functions and calculate number of
hours:minutes. I have entered dates and times using the
date format [8/15/03 18:30] and [8/17/03 10:10]. I am
trying to calculate to number of hours:min between the two
values. Would appreciate any suggestions to accomplish.
 
I am able to subtract dates and subtract times; however, I
want to combine the two functions and calculate number of
hours:minutes. I have entered dates and times using the
date format [8/15/03 18:30] and [8/17/03 10:10]. I am
trying to calculate to number of hours:min between the two
values. Would appreciate any suggestions to accomplish.
Click to expand...

With your earlier date in A1 and your later date in B1, the formula would be
=B1-A1

A1: 8/15/03 18:30
B1: 8/17/03 10:10

=B1-A1: 39:40


Format the result as [h]:mm to obtain in the format you specified.


--ron
 
Back
Top