Subtract Datetime

Sankur · #1 (**permalink**) 11-19-09, 14:27

Hi,

I have 2 datetime fields and i would like to find the difference of the two and display in a third field. How will it be done?

ScanDateTime & DataDateTime : yy/mm/dd hh:mm:ss format
Longest Time : hh:mm:ss format

The fields i have are:

Code:

ScanDateTime            DataDateTime              Longest Time
09/11/15 05:00:00      09/12/03 10:47:00             ???

Sankur.

Ax238 · #2 (**permalink**) 11-19-09, 16:02

Just enter a formula in the Longest Time of B2-A2 and then format it the way you want. For example, you could format it as follows to get it to say "18 days, 05 hours, 47 minutes":

Code:

dd "days," hh "hours," mm "minutes"

You could also just format the cell as a number and get a value of 18.24.

Ax

Sankur · #3 (**permalink**) 11-19-09, 23:47

Ax,

I used the "B2-A2" way to get the Longest TIme and set the format as "Custom - hh:mm:ss", but im not getting the corrext value.

Code:

ScanDateTime            DataDateTime              Longest Time
09/11/15 05:00:00      09/12/03 10:47:00           05:47:00

I want the time to be shown in the "hh:mm:ss" format. But it is not working.

Sankur.

Colin Legg · #4 (**permalink**) 11-20-09, 05:30

If you want the day difference to be accrued within the hours then change the custom format to [hh]:mm:ss

That would display a result of 437:47:00

Hope that helps...

Sankur · #5 (**permalink**) 11-20-09, 14:15

Thanks - i got it now.

Internet Services

Web Development

Digital Marketing

Consumer Tech