| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Show a time from one calculated cell as a decimal in another cell.
I have a SUM OF cells that are formatted as time [add the hours worked for a
dozen individuals] 135:24. One hundred thirty five hours and 24 minutes. I would like to have another cell look at that number and show it as 135.24 in another cell. I don't want the decimal version of the 135:24 [5.81]. I want to cell to contain the value of 135.24. This is pretty urgent - so if anyone can help that would be GREAT! Thank you. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get one cell to record the time another cell was changed. | Excel Discussion (Misc queries) | |||
| Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
| Combined date time cell to separate date & time components | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
| cell reference show cell name (ie. D45) and not cell value | Excel Worksheet Functions | |||
Threaded Mode
