Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Good Morning -
What I am looking to do is take the time in/time out and add it to the time in/time out (lunch in the middle); allow for a rounder of 7 minutes, round down, 8+ round up. Then add, PTO, Holiday or Bereavement leave for that day. Here is an example: Monday, March 17 Tuesday, March 18 7:55am 7:52am 12:02pm 12:30pm 12:58pm 5:08pm 2.75 - PTO Total Hours: 8.25 7.50 Total hours worked per day, should equal 7.5 or greater. THANK YOU! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Timesheet - | Excel Discussion (Misc queries) | |||
Timesheet | Excel Discussion (Misc queries) | |||
need to create a formula to create a timesheet but haven't a clue | Excel Discussion (Misc queries) | |||
Timesheet | Excel Worksheet Functions | |||
TIMESHEET FORMULA | Excel Worksheet Functions |