Hi -
I have a timesheet that calculates the time in and out and totals the hours worked (formatted as [hh]:mm). There are also fields where an employee will put in whole numbers for hours (i.e. 3 hours personal, 4 hours vacation, etc.) that are formatted as a number. I need to total the manually entered hours plus the total hours worked. for example
..................................................................... [(hh]:mm) / (number)
TIME IN / TIME OUT / TIME IN / TIME OUT / TOTAL HOURS / SICK TIME
8:05 AM / 9:10 AM / 1:20 PM / 6:05 PM / 6.00 / 2.00
Total Hours + sick time should equal 8 but I am getting 2.25.
The times in and our are all formatted using a 7 minute rounding rule calculation and custom formatted as [hh]:mm.
Any suggestions on how to get this to sum correctly? I'm sure it's something simple that I am overlooking. Thanks for your help!
Laura~
I have a timesheet that calculates the time in and out and totals the hours worked (formatted as [hh]:mm). There are also fields where an employee will put in whole numbers for hours (i.e. 3 hours personal, 4 hours vacation, etc.) that are formatted as a number. I need to total the manually entered hours plus the total hours worked. for example
..................................................................... [(hh]:mm) / (number)
TIME IN / TIME OUT / TIME IN / TIME OUT / TOTAL HOURS / SICK TIME
8:05 AM / 9:10 AM / 1:20 PM / 6:05 PM / 6.00 / 2.00
Total Hours + sick time should equal 8 but I am getting 2.25.
The times in and our are all formatted using a 7 minute rounding rule calculation and custom formatted as [hh]:mm.
Any suggestions on how to get this to sum correctly? I'm sure it's something simple that I am overlooking. Thanks for your help!
Laura~