| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If statement to work out time/overtime
Hi guys, I am having trouble with a formula if anybody can help please.
I have two cells A1 & B1 that holds start time and end time of work done. I then have another two cells C1 & D1. C1 is normal hours worked and D1 is overtime. I am looking for two formula's. For example lets use below data: A1 B1 05:00 19:00 C1 should work out the time between 08:00 and 17:00 and display "09:00" hours D1 should work out overtime, (hours worked before 08:00 and after 17:00) and display "05:00" Ive been running around with If, And and subrtracting MAX statements but cant find one that works. Please help! Conrad |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Work hours with overtime | Excel Discussion (Misc queries) | |||
| Calculating Regular time, overtime and double time | Excel Worksheet Functions | |||
| Detailed Time Sheet (overtime, comp time, vacation used) | New Users to Excel | |||
| Work out overtime hours for individuals | New Users to Excel | |||
| Work out overtime hours for individuals | New Users to Excel | |||
Threaded Mode
