HOW TO I CALCULATE HOURS AND MINUTES? NEED FORMULA
 

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

HOW TO I CALCULATE HOURS AND MINUTES? NEED FORMULA
 

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


"Babs" wrote:

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

HOW TO I CALCULATE HOURS AND MINUTES? NEED FORMULA
 

=OUT-IN

if the time can pass midnight

=OUT-IN+(INOUT)

or

=MOD(OUT-IN,1)


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"Babs" wrote in message
...
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