- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
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
Views
Replies
Total Likes