AnsweredAssumed Answered

Timesheet calculation

Question asked by LouRuby on Feb 17, 2014
Latest reply on Feb 18, 2014 by philmodjunk


Timesheet calculation


     I am trying to create a timesheet i have 4 fields (AMTimeIn, AMTimeOut, PMTimeIn, PMTimeOut) everything works great until one of the fields is left empty. EX: 6:30AM to 12:00PM 12:30PM to 3:00PM will result in 8 hours worked. but if one of the fields is left blank it miscalculates the total hours worked. any suggestions would be greatly appreciated...thx