Need difference in Hrs.mm.ss

[siva]

Hi Everyone,

Below given are the inputs which is in MM/DD/YYYY Hrs:mm:ss format. I
would like to have the difference between both the dates in Hrs:mm:ss
format. Please help.

A B
6/1/2010 8:05 6/2/2010 17:18
6/1/2010 8:51 6/3/2010 10:42
6/1/2010 8:35 6/1/2010 8:39
6/1/2010 9:57 6/4/2010 8:17
6/1/2010 11:07 6/2/2010 18:26
6/1/2010 13:18 6/7/2010 23:26
6/1/2010 15:51 6/4/2010 14:29
6/1/2010 17:19 6/1/2010 22:56
6/1/2010 17:06 6/4/2010 17:10
6/1/2010 18:55 6/3/2010 2:14

Cheers,
Sivaji

 

[Pete_UK]

If those are proper Excel dates and times, then you can just subtract
one from the other, i.e.:

=B1-A1

and apply a custom format to the cell of:

[h]:mm:ss

Then copy it down. The square brackets prevent the hours wrapping to
days at 24 hour increments.

Hope this helps.

Pete

 

[siva]

If those are proper Excel dates and times, then you can just subtract
one from the other, i.e.:

=B1-A1

and apply a custom format to the cell of:

[h]:mm:ss

Then copy it down. The square brackets prevent the hours wrapping to
days at 24 hour increments.

Hope this helps.

Pete

Hi Everyone,

Below given are the inputs which is in MM/DD/YYYY Hrs:mm:ss format. I
would like to have the difference between both the dates in Hrs:mm:ss
format. Please help.

        A                              B
6/1/2010 8:05   6/2/2010 17:18
6/1/2010 8:51   6/3/2010 10:42
6/1/2010 8:35   6/1/2010 8:39
6/1/2010 9:57   6/4/2010 8:17
6/1/2010 11:07  6/2/2010 18:26
6/1/2010 13:18  6/7/2010 23:26
6/1/2010 15:51  6/4/2010 14:29
6/1/2010 17:19  6/1/2010 22:56
6/1/2010 17:06  6/4/2010 17:10
6/1/2010 18:55  6/3/2010 2:14

Cheers,
Sivaji- Hide quoted text -

- Show quoted text -

Thanks a lot Pete.... I didnt know that the Square brackets would help
in such a way...

Cheers,
Sivaji

 

[Pete_UK]

You're welcome, Sivaji - thanks for feeding back.

Pete