Chip Pearson has lots of date & time math info at his site:
http://www.cpearson.com/excel/datetime.htm#AddingTimes
"Corby" wrote:
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