LinkBack URL
About LinkBacks
Hi,
Please find my attached excel sheet, here i Require Time difference in mm/dd hh:mm, how do i go about this.
Am really hoping this forum could help me.
Thanks,
Aaron.
Hi,
Please find my attached excel sheet, here i Require Time difference in mm/dd hh:mm, how do i go about this.
Am really hoping this forum could help me.
Thanks,
Aaron.
Hi aaron lewis
For the time difference, do you mean in hours & minutes!
In C2:
=B2-A2
Format the cells as "[h]:mm" and copy down.
Regards Kevin
Merged Cells (They are the work of the devil!!!)
If mm/dd means months and days try this formula
=TEXT(DATEDIF(A2,B2+(MOD(B2,1)>MOD(A2,1)),"m"),"00\/")&TEXT(DATEDIF(A2,B2+(MOD(B2,1)>MOD(A2,1)),"d"),"00 ")&TEXT(B2-A2,"hh:mm")
Audere est facere
ok i get the output asOriginally Posted by daddylonglegs
Approval Date1 in mm/dd/yyyy hh:mm Approval Date2 in mm/dd/yyyy hh:mm Require Time difference in mm/dd hh:mm
11/16/2012 09:41 11/20/2012 05:36 00/04 19:54 which is proper as 4 days and 19 hrs
Can i get the output only in hours or preferably minutes.
Like for hours : 4days*24 + 19 hrs = 115 hours
or for minutues: 4days*24*60 + 19*60 + 54 = 6954 minutes
i just realised that the difference should be shwoing 3 days and 19hrs and not 4 days and 19 hrs!!
Yes, apologies, to get the correct result in format mm/dd hh:mm this is the correct version
=TEXT(DATEDIF(A2,B2-(MOD(B2,1)<MOD(A2,1)),"m"),"00\/")&TEXT(DATEDIF(A2,B2-(MOD(B2,1)<MOD(A2,1)),"d"),"00 ")&TEXT(B2-A2,"hh:mm")
....but if you want the result in just hours or minutes that can be done more simply as Kevin suggests....
What are you trying to do!!!
Look at post #2
For minutes, format as [m]
Or use =(B2-A2)*1440
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks