LinkBack URL
About LinkBacks
Hi,
I seek for your help.
This tracker needs configuration.
Please try to fix the formula. I'm having trouble with the time it wont give me a correct result. instead give me #######.
Attendance_.xlsx
Hi,
I seek for your help.
This tracker needs configuration.
Please try to fix the formula. I'm having trouble with the time it wont give me a correct result. instead give me #######.
Attendance_.xlsx
You need to correct you IFERROR statement. Use "" or 0 for Value if error
If I've helped U pls click on d *Add Reputation
Tardy MINS:
=IF(TimeIn="","",IFERROR(TimeIn-TIMEVALUE(CHOOSE(MorningFlag,StartTime,"13:30")),""))
Under Time:
=IF(TimeOut="","",IFERROR(TimeOut-TIMEVALUE(CHOOSE(AfternoonFlag,TimeOut,OutTime)),""))
Originally Posted by bhenlee
Can you fixed the spreadsheet pls?
Still getting errors. Our regular schedule is 8:30 PM to 5: 30 AM
You're getting an error because excel has nothing to compute if the associate is not tardy nor incurred an undertime.
try this:
For Tardy Mins: =IF(TimeIn="","",IF(TimeIn<StartTime,0,IFERROR(TimeIn-TIMEVALUE(CHOOSE(MorningFlag,StartTime,"13:30")),TimeIn-StartTime)))
For Undertime: =IF(TimeOut="","",IF(TimeOut>OutTime,0,IFERROR(TimeOut-TIMEVALUE(CHOOSE(AfternoonFlag,TimeOut,OutTime)),OutTime-TimeOut)))
Let me know if it works...
Your formula does not compute instances where the Timein crosses over 12MN..
Let me know if this simple formula would do:
Tardy: =IF(B10="","",(B10+(StartTime>B10)-StartTime)*24*60)
Undertime: =IF(C10="","",(OutTime+(C10>OutTime)-C10)*24*60)
Format to General. You want the minutes to show.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks