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
|