HOW TO I CALCULATE HOURS AND MINUTES? NEED FORMULA

[Guest]

I know this is simple, but I can't seem to figure it out. I need to
calculate the amount of hours and minutes worked from beginning time to end
time:
IN OUT TOTAL (time worked)
9:10 3:10 6:00 hrs.

My is blank and I've already been playing with formulas for hours...would
appreciate a formula.....THANKS

 

[Guest]

Just subtract your IN time from your OUT time. Since you're using a 12 hour
clock, make sure that the appropriate AM or PM is attached to your times,
otherwise 3:10 will be treated as 3:10am.

HTH,
Elkar

 

[Peo Sjoblom]

=OUT-IN

if the time can pass midnight

=OUT-IN+(IN>OUT)

or

=MOD(OUT-IN,1)


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com