![]() |
|
#3
|
|||
|
|||
|
Hope this helps:
All calculations are on Row 5 for that day, Monday The next days hours will follow are on the next Rows as needed. "A" Column Time Start in Military Time Format (18:00) "B" Column Time Stop in Military Time Format (08:00) What's need to calculate from Columns "A" & "B". "C" Column Total Regular Hours worked in NUMERICAL Value (8.0) "D" Column Total Overtime Hours (if any over Regular Hours) in NUMERICAL Value (2.0) Have I confused everyone yet?! |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
PMT Formula
|
OneOleGuy | Excel | 4 | 03-05-2011 09:54 AM |
Help with Formula
|
Corca | Excel | 6 | 02-22-2010 09:40 PM |
Timesheet formula help
|
beardking | Excel | 2 | 11-10-2009 02:06 AM |
If formula
|
sixhobbits | Excel | 1 | 10-02-2009 08:02 AM |
| Help for formula | dehann | Excel | 5 | 05-01-2009 10:44 AM |