LinkBack URL
About LinkBacks
6/5/2012 12:10 - 6/12/2012 17:05 = 7.204861
7 days and (.204861 x 24) = 5 hours
I have a long list and I'm trying to use a formula to separtate the part after the decimal point to get the hours.
6/5/2012 12:10 - 6/12/2012 17:05 = 7.204861
7 days and (.204861 x 24) = 5 hours
I have a long list and I'm trying to use a formula to separtate the part after the decimal point to get the hours.
when you subtract 6/5/2012 12:10 from 6/12/2012 17:05, the result (214.2048611) can be made to spit out the decimal portion thus:
to extract the portion before the decimal, you would use:
Please Login or Register to view this content.
Please Login or Register to view this content.
- i.s.z -
CSE, aka Array aka { }, formulae are confirmed with CONTROL+SHIFT+ENTER.
Replace commas ( , ) with semicolons ( ; ) in formulae, if your locale setting demands.
All good ideas are courtesy resources from this forum as well as others around the web.
- e.o.m -
Assuming the results 7.204861 are in cell C1 try the following formula
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks