Time problem, Auto calculation???

F

Frantic3d

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
 
B

Biff

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query TIME saved as TEXT to Sort PROPERLY (e.g. 1:36 PM to list after 10:00AM) ? 4
time sheet claculation 4
time calculation, 24:00 - 16:00 = 8 3
time calculation, 24:00 - 16:00 = 8 4
TIME CALCULATION 5
How do I analyze data using time periods? 1
Time Calculation Question 4
Countif function to show how often numbers within a range are pres 3

Top