MrExcel Publishing
Your One Stop for Excel Tips & Solutions

time conversion


Posted by J Stritchko on January 27, 2002 6:05 PM

I need the formula to convert time posted in 1) hours and hundredths to hours and minutes and 2) from hours and minutes to hours and hundredths.

Thank you


Posted by Barrie Davidson on January 27, 2002 6:31 PM

1) =A1/24, and custom format the cell as [h]:mm

2) =A1*24, and format the cell as number

Hope this helps you out.
Regards,
BarrieBarrie Davidson