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

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