| 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. |
|
#2
|
|||
|
|||
|
Kathy,
Sure you mean 135:24 - 135.24, not 135.4? assuming so,. then =INT(H1*24)+MOD(H1*24,1)*0.6 make sure it is formatted as decimal not time -- HTH Bob Phillips "KathyS" wrote in message ... 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. |
| Reply |
| 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 | |||
Linear Mode
