Lost in Overtime Computations

  • Thread starter Thread starter b52gnav
  • Start date Start date
B

b52gnav

If you don't mind helping a novice, I need your assistance in creating
simple formula (for some people) which will help me calculat
overtime/comptime hours.

I've tried and tried and have come up blank, and I'm sure the answer i
simple (for those in the know). Basically, I work a 0730 to 1730 job.
I am trying to accurately track my times daily.
Our pay system requires out times to be converted into "hundredths" o
an hour but gets rounded to the nearest 15 minutes for overtime an
comptime. I usually arrive to work between 0700 and 0730 then leav
between 1630 and 1830. I must round my hours worked to the nearest 1
minutes at the end of each work day, then total them at the end of eac
week.

I can send my spreadsheet if you'd like to see what I've done so far.

B5
 
To calculate the rounded time, assuming start in A1, end in B1

=ROUND((B1-A1)*96,0)/96

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top