Time formatting

D

dziw

Hi
Just a quick question one of my calculations returns a length of tim
in hours in a decimal format. I was wondering if there was a way t
format the cell so that for example if the figure 53.5 was returne
then the cell would display the value 53:30
(for 53 hours 30 minutes). the best that i can get so far is using "
?/60" to return:
53 30/60
This isn't as neat as i would like. I have tried the date/tim
formatting options but they only seem to return things like 12:00:00.
Any ideas
 
B

Bob Phillips

Don't think it can be done as the decimal part refers to parts of 60, not
parts of 10/100/1000 etc, so it needs a conversion, which isn't a natural
facet of formatting.
 
N

nsv

I do not think there is any format, but you can create something like
it. If you assume the result of your calculations is in cell A1, then
In cell A2 write:
=INT(A1)&":"&ROUND((A1-INT(A1))*60;0)
In stead of "A1" you can write your calculation, but then it can get a
little complicated

NSV
 
Top