The formula for displaying absenteeism coming earlier in minutes?

[itgldmrt]

I have employee attendance data with a tardiness formula in minutes, but I was assigned to create a formula for employees who arrive early in minutes.
The following is the formula for employee late attendance that I created:

=IF(RUMUS!F10>'ABSENSI DATANG TELAT'!$B$3,RUMUS!F10-'ABSENSI DATANG TELAT'!$B$3,0)

I've tried reversing the formula from ">" to "<" but it doesn't work. Do you have a solution?

 

[kevin9999]

Did you reverse the last two values in the formula as well as reversing the "<"? Like this:

=IF(RUMUS!F10<'ABSENSI DATANG TELAT'!$B$3,'ABSENSI DATANG TELAT'!$B$3-RUMUS!F10,0)

 

[itgldmrt]

Did you reverse the last two values in the formula as well as reversing the "<"? Like this:

=IF(RUMUS!F10<'ABSENSI DATANG TELAT'!$B$3,'ABSENSI DATANG TELAT'!$B$3-RUMUS!F10,0)

Thanks, it works. But if the time in attendance is empty then the time appears to be 8:30 which is $B$3. I want if the absence is empty then that column remains empty.

 

[kevin9999]

If "time in attendance" is F10, then you could try the following:

=IF(RUMUS!F10<>"",IF(RUMUS!F10<'ABSENSI DATANG TELAT'!$B$3,'ABSENSI DATANG TELAT'!$B$3-RUMUS!F10,0),"")

 

[itgldmrt]

If "time in attendance" is F10, then you could try the following:

=IF(RUMUS!F10<>"",IF(RUMUS!F10<'ABSENSI DATANG TELAT'!$B$3,'ABSENSI DATANG TELAT'!$B$3-RUMUS!F10,0),"")

Thank you so much @kevin9999 it works perfectly. You're a master

 

[kevin9999]

Thank you so much @kevin9999 it works perfectly. You're a master

Happy to help, and thanks for the feedback