Forum Discussion
Overtime, Normal Time Calculations
Hi all, full disclosure i'm pretty new to this. What i'm trying to do is two steps. One is to calculate the total hours worked per job which is calculated from three columns, travel start time, tra...
GrakeBliffin , Not very clear, But you need these column, some of them can be var in a new column
Arrival Time = datediff([Travel Start Time], [Arrival Time], Second)//you can use minute or hour
Actual Time = datediff([Travel Start Time], [CompletionTime], Second)//you can use minute or hour
compare these to
if([Actual Time] <= [Arrival Time], "Ontime", "Over Time")