Calculating days and hours
Well, after reading a bit closer about MOD, which I should have done to start
with, I see that it will not do what I want to do. Any more suggestions?
Thanks...
"JE McGimpsey" wrote:
Hmmm.. 12.375 days would translate to 12 days 9 hours, wouldn't it?
IF (a) all your time spans are less than 32 days, and (b) you're using
the 1900 date system, you could just choose Format/Cells/Number/Custom:
d "days" h "hrs."
(which will round to the nearest hour).
Otherwise you could use
A1: 12.375
B1: =INT(A1) & TEXT(A1," \da\y\s h \hr\s.")
In article ,
Woodturner wrote:
How can I convert decimal days, eg 12.375 days, to days and whole hours? Ex.
12 days 3 hrs.?
|