Employee time sheet

A

annette

I am trying to create an employee time sheet in excel. Currently, I have
start time (cell B1), end time (cell B2), and total hours worked (cell
B3). The cells are formatted 'hh:mm'. Cell B3 (total hours) contains
the formula: B2-B1+IF(B1>B2,1). This appears to calculate correctly for
all variations of a.m. and p.m. start and end time.

Many of our employees work shifts and/or irregular hours. I want to
calculate the amount of overtime worked in a day/shift. A regular day
or shift equals 8 hrs. If, for instance, an employee works 8 hrs and 15
mins, the total might read 8:15 (in cell B3 above).

What formula can I use to calculate the 15 minutes overtime?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate difference between hours 5
Simple Time sheet, calculate OT 2
To find out the total number of hrs worked in a week 2
Calculate Face Time 4
Adding up total hours worked on employee schedule using various criteria 0
complex overtime/late shift compensation calculations 2
TimeSheet Using 100 Minutes & Rounding to .25 2
Basic Formula question 6

Top