| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
convert work hours
Please help€¦. What is the formula to convert 1.0 days into 8.0 hours????
Thank you in advance |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Determining work hours between dates / hours | Excel Worksheet Functions | |||
| convert 8 hours and 45 min in to 8.75 hours. | Excel Worksheet Functions | |||
| Work Hours | Excel Worksheet Functions | |||
| Need to convert hours and minutes to hours and tenths. | Excel Discussion (Misc queries) | |||
| Convert hours and minutes in time format into fractions of hours.. | Excel Worksheet Functions | |||
Linear Mode
