Need difference in Hrs.mm.ss

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
 
P

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
 
S

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top