| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Time problem, Auto calculation???
Hello all,
I'm trying to create my own time sheet. Inputing 24 hr time format works just fine. Format is subtract morning(start) from afternoon(end). yeilds the correct results. Problem, I'd like to input standard 12 hr time. I can't get this to work correctly. Is there a formula to convert 12hr time to 24hr time? TIA Frantic3D |
|
#2
|
|||
|
|||
|
Hi!
Not sure what you're asking.... If you want the result to be a decimal value 8 vs 8:00 =(your_formula)*24 Biff "Frantic3d" wrote in message ... Hello all, I'm trying to create my own time sheet. Inputing 24 hr time format works just fine. Format is subtract morning(start) from afternoon(end). yeilds the correct results. Problem, I'd like to input standard 12 hr time. I can't get this to work correctly. Is there a formula to convert 12hr time to 24hr time? TIA Frantic3D |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto Calculation Setting | Excel Discussion (Misc queries) | |||
| Time Sheets | Excel Discussion (Misc queries) | |||
| Time Calculation | Excel Worksheet Functions | |||
| elapsed time calculation | Excel Discussion (Misc queries) | |||
| time formatting and time categorizing (vlookup or data validation) | Excel Worksheet Functions | |||
Linear Mode
