Need difference in Hrs.mm.ss

  • Thread starter Thread starter siva
  • Start date Start date
S

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
 
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
 
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,
Click to expand...
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.
Click to expand...
        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
Click to expand...
Cheers,
Sivaji- Hide quoted text -
Click to expand...

- Show quoted text -
Click to expand...

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

Cheers,
Sivaji
 
Back
Top