Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Calculating Overtime from Hours total
I am working with a bi-weekly timesheet that calculates total hours in
decimal format. I need to calculate the overtime after 8 hours in a day. C10 shows a clock in time of 8:39 D10 shows a clock out time of 13:00 E10 shows a clock in time of 13:30 F10 shows a clock out time of 17:14 formula in G10 is as follows --- =(D10-C10+F10-E10)*24 giving a total of 8.08 hrs worked H10 needs to show ONLY the .08 of the 8.08 AND is there a way to make the hours in G10 not show hrs in excess of 8.00 at the same time? Your help is appreciated!! Dreamweavn |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculating timesheet, time-in/time-out = total hours & minutes, . | Excel Worksheet Functions | |||
need help w/formula for calculating overtime hours | Excel Worksheet Functions | |||
Problems calculating total hours | Excel Discussion (Misc queries) | |||
Subtracting paid hours from unpaid hours | Excel Worksheet Functions | |||
Help! I am stuck calculating Days, Hours, Mins please help | Excel Worksheet Functions |