I currently have a calculation using two date fields "start time" and "end time along with a lunch duration field to give me a total hours for a work day but now I would like to add two more calculation fields to break out overtime and double overtime. My current calculation looks like this:
var t1 = moment(@Start Time);
var t2 = moment(@End Time);
var t3 = @Lunch Duration;
var result = t2.diff(t1, 'hours') - t3;
I'm thinking my next calculation would be something like: if @Work Hours >8 and <=12 then - 8 if >12 = 12 ??
And Double would just be if @Work Hours >12 then - 12
Anyone have an idea?
Please sign in to leave a comment.