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
|