View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Elkar
 
Posts: n/a
Default 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