CODEWITHSUNDEEP
exceldatetime
Darjeeling
Darjeeling

Reputation: 999

calculate the difference between two dates and time on excel

I want to calculate the difference between two dates and time and the result should be on "hh:mm:ss"

   |           E          |           F         |    G     |
===+======================+=====================+==========+
3  | 01/01/2013  13:34:50 | 31/01/2013  7:34:05 | 17:59:15 |

I tried this =TEXT(F3-E3;"hh:mm:ss") but it only count the difference from times, not date. I also tried to add dd like this: =TEXT(F3-E3;"dd hh:mm:ss") It works, but that's not the result I'm looking for.

Upvotes: 8

Views: 36959

Answers (2)

Doug Glancy
Doug Glancy

Reputation: 27478

I think this is what you want:

=TEXT(F3-E3;"[h]:mm:ss")

Upvotes: 12

user9195988
user9195988

Reputation: 41

I think the semicolon should be replaced with a comma:

=TEXT(E5-D5,"[h]:mm:ss")

Upvotes: 3

Related Questions