Convert number to days - hours - minutes

[rsikin]

Hello Excel Users

I would like to convert a number (73.60) to days, hours & minutes to track how much sick or vacation time I have.

Thanks
Robert

[thomach]

This is fairly easy to do in Excel. Excel stores dates and time as numbers with each integer equal to one day. So 0.5 is 12 hours, for example. 1.5 would equal 36 hours.

What units is your 73.60 in? If it's hours, divide it by 24 to convert it to Excel days and set your cell's format to CUSTOM > dd:hh:mm

If it's in days already, just set the format.

EDIT: Oops, I should have tested first. This format does not work for greater than 24 hours. Some fancier formulas are, I think, needed.

[h]:mm will display hours (beyond 24) and minutes, but this is not what you asked.

[thomach]

Adendum. If your 73.60 is in hours in cell A1, then in another cell (I'll use C1), enter:

=INT(A1/24)

to get the number of days.

format another cell to hh:mm and enter:

=(A1-24*D1)/24

This will display the hours and minutes.

[Barbarr]

Something like this might help you!

[thomach]

Adendum II:

Also see Dave's tutorial on working with Dates and Times.

http://www.ozgrid.com/Excel/ExcelDateandTimes.htm

And (I forgot to say) Welcome to OzGrid

[Barbarr]

Cool Tomach but just for clarity, I think you meant:

format D1 to hh:mm and in D1 enter:

=(A1-24*C1)/24

[rsikin]

That was awesome!

Thank you very much thomach & Barbarr.