Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I am calculating overtime and have a time of 25:28. That is 25 hours and 28
minutes. It is formatted Custom [h]:mm so you actually see the 25:28 in the cell. I want to pull the hours into a sererate cell as 25 in this case. I keep getting a 1 and if I try to add this hour and another number it gives me another confusing answer. My question is how do I return the hours (25 in this case) to its own cell and have it actually be a value of 25. Thank you for your help. Steven |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Date & Time | New Users to Excel | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
Find a Function to use accross different worksheets | Excel Worksheet Functions |