| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting Time from Hours and Minutes Decimals in a formula
Two cell in a Excel Spread sheet next to each other one has regular time
format and the other is in Decimal for operating and running times. I cant alter the sheet format but have un-merged the two cell for both types of times. CAN ANYONE PLEASE HELP ASAP THANKS SARGE |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Converting Time from Hours and Minutes Decimals in a formula
If you have time in decimals then multiplying it by 24 would give you the
hours and minutes in decimal... "SARGE" wrote: Two cell in a Excel Spread sheet next to each other one has regular time format and the other is in Decimal for operating and running times. I cant alter the sheet format but have un-merged the two cell for both types of times. CAN ANYONE PLEASE HELP ASAP THANKS SARGE |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting Time to Hours & Minutes | Charts and Charting in Excel | |||
| Converting total minutes into hours and minutes in Excel | Excel Worksheet Functions | |||
| Problem with converting decimal time to hours and minutes | Excel Discussion (Misc queries) | |||
| decimals as hours change to minutes | Excel Discussion (Misc queries) | |||
| Converting a decimal time into hours and minutes | Excel Worksheet Functions | |||
Linear Mode
