Time Calculation

[Guest]

I am calculating the amount of time that an employee is tardy. I am using
the following expression: TardyTime:
Format([ATIME]/1440)-([SHSTART]/1440),â€h:nnâ€). The problem I have is that if
an employee punches in early the expression doesn’t return a negative amount
of time. How do I get the expression to return a negative amount of time for
punches prior to the scheduled start time and a positive amount of time for
punches after the scheduled start time? I’ve also tried an IIf statement,
TardyTime:
Format(IIf(([SHSTART]/1440)>([ATIME]/1440),([SHSTART]/1440)-([ATIME]/1440)*-1,([SHSTART]/1440)-([ATIME]/1440)),"h:nn").

Thanks for your help.

 

[Allen Browne]

See:
Calculating elapsed time
at:
http://allenbrowne.com/casu-13.html

The article explains how (and why) to get the result in minutes, and then
display it as hours and minutes.

 

[Guest]

Worked great, thanks!

See:
Calculating elapsed time
at:
http://allenbrowne.com/casu-13.html

The article explains how (and why) to get the result in minutes, and then
display it as hours and minutes.
--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

I am calculating the amount of time that an employee is tardy. I am using
the following expression: TardyTime:
Format([ATIME]/1440)-([SHSTART]/1440),"h:nn"). The problem I have is that
if
an employee punches in early the expression doesn't return a negative
amount
of time. How do I get the expression to return a negative amount of time
for
punches prior to the scheduled start time and a positive amount of time
for
punches after the scheduled start time? I've also tried an IIf statement,
TardyTime:
Format(IIf(([SHSTART]/1440)>([ATIME]/1440),([SHSTART]/1440)-([ATIME]/1440)*-1,([SHSTART]/1440)-([ATIME]/1440)),"h:nn").

Thanks for your help.