Thread: [Solved] Timesheet formula
View Single Post
 
Old 05-26-2011, 02:29 PM
IndCom IndCom is offline Windows XP Office 97
Novice
 
Join Date: May 2011
Posts: 8
IndCom is on a distinguished road
Default

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?!
Reply With Quote