My formula needs to count from an absolute reference.

I.E.

=IFERROR((HOUR(U$28)-(HOUR($U16)*1)),"ABSENT")

U$28 being the absolut reference and $U16 being the actual log in time.

for example, U$28 = 11:00 PM and $U16 = 12:00 AM

What happens to the formula is that it counts starting from AM to PM.

so instead of it reflecting 1 hour it reflects 23 hours.



I HOPE SOMEONE CAN HELP ME ON THIS.