| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
convert a summed time value to hours only
Would like to convert the sum total of time values to hours only. Example is 286:30:00 convert to 286.5 hours |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
convert a summed time value to hours only
Multiply by 24 as time is stored as a fraction of 1 day
-- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "Jay" wrote in message ... Would like to convert the sum total of time values to hours only. Example is 286:30:00 convert to 286.5 hours |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
convert a summed time value to hours only
=A1*24 and format as GENERAL
"Jay" wrote: Would like to convert the sum total of time values to hours only. Example is 286:30:00 convert to 286.5 hours |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
convert a summed time value to hours only
ty
"Jay" wrote: Would like to convert the sum total of time values to hours only. Example is 286:30:00 convert to 286.5 hours |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I convert a # into a time format in Excel, Ex.845 to 8:45 | Excel Worksheet Functions | |||
| convert military time to regular hours | Excel Worksheet Functions | |||
| How to set a formula to convert the time zone | Excel Worksheet Functions | |||
| HOURS DIFFERENCE IN TIME BETWEEN DIFFERENT DATES AND TIMES | Excel Worksheet Functions | |||
| Calculate difference in time spanning a day, during office hours o | Excel Discussion (Misc queries) | |||
Linear Mode
