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?
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?