convert work hours
 

Please help€¦. What is the formula to convert 1.0 days into 8.0 hours????
Thank you in advance

convert work hours
 

On Dec 29, 6:06*pm, Carolina Girl
wrote:
Please help…. What is the formula to convert 1.0 days into 8.0 hours????
Thank you in advance

If you have the number of days in A1 then perhaps

=A1*8

to get 8......or if you want 8:00 in time format then use

=A1*8/24

format result cell to show as time, i.e [h]:mm

convert work hours
 

=1*8


Gord Dibben MS Excel MVP

On Mon, 29 Dec 2008 10:06:01 -0800, Carolina Girl
wrote:

Please help…. What is the formula to convert 1.0 days into 8.0 hours????
Thank you in advance