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

New here and I hope you folks can help. Because I've frazzled my brains trying to figure this one out.

Could someone please provide me with the following formulas?

This is for a daily calculation - no break columns are used.

MONDAY
Col A5 Time Start in Time Format 10:00 PM
Col B5 Time Stop in Time Format 8:00 AM

And here's where I need the formulas:

Col C5 Total Regular Hours in Numerical Value example ( 8.0 )
Col D5 Total Overtime Hours in Numerical Value example ( 2.0 )

Much help needed and many thanks for your considerations!
Reply With Quote