how do u find difference between 2 times in yyyy.mm.dd hh:mm format in excel 07, i've spent hrs trying to reformat the cells, tried every concoction and all i keep getting is #VALUE!
col A
2010-12-27-06:27
2010-12-27-08:45
2010-12-27-09:37
2010-12-27-10:33
col B
2010-12-27-08:10
2010-12-27-09:15
2010-12-27-10:29
2010-12-27-13:38
and i'm trying to subtract A from B but getting nowhere, i'm trying to get the answer in dd-hh:mm
i'm looking for the time elapsed.
thanks for any help anyone can give
Last edited by PooH; 07-09-2011 at 01:11 PM.
Normally B-A would do.
To be sure, post a sheet with the data ( or a sample)
Try
Please Login or Register to view this content.
EDIT : the "*1" are not necessaryPlease Login or Register to view this content.
Last edited by arthurbr; 07-09-2011 at 12:50 PM.
I am attaching the sample data sheet for more clear undersatnding.....
Try the formula I posted under #3
Hi arthurbr,
Thanks for the reply but the given formula does not work....
I tried the formula posted under #3 but still it is not able to calculate elapsed time.....
That is normal, because you changed the format between your original post and the sheet you provided
This should do
EDIT Then format as you needPlease Login or Register to view this content.
Last edited by arthurbr; 07-09-2011 at 01:04 PM.
This is awesome...this is exactly what i was looking for.
Thanks arthurbr for your help.....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks