Divide by 24.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"Corby" wrote in message
...
I am having a problem converting a numeric format to a time
format.
3.5 to 3hour 30 minutes
I need to be able to add up all hours for a time keeping
function.
Thanks,
Corby