Convert numeric to time
 

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

Convert numeric to time
 

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

Convert numeric to time
 

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