Avatar

Not applicable

Steve,

Will your formcalc setup work with times past midnight as well? If they do can you send them to me tychis@esthesis.net. If they do not can you assist me in doing a time sheet that will calculate past midnight.

I use the following formcalc formula for a standard 8-5 day

Time2Num(t1,"h:MM A")

Time2Num(t2,"h:MM A")

Time2Num(t2,"h:MM A")-Time2Num(t1,"h:MM A")

var

StartInterval=0

if

(HasValue(t1) and HasValue(t2))then

StartInterval=Time2Num(t2.formattedValue,"h:MM A")-Time2Num(t1.formattedValue,"h:MM A")

endif

Time2Num(t3,"h:MM A")

Time2Num(t4,"h:MM A")

Time2Num(t4,"h:MM A")-Time2Num(t3,"h:MM A")

var

EndInterval=0

if

(HasValue(t3) and HasValue(t4))then

EndInterval=Time2Num(t4.formattedValue,"h:MM A")-Time2Num(t3.formattedValue,

"h:MM A")

endif

Sum(StartInterval+EndInterval)/3600000

thanks