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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks