Hi
I have a query with two calculated fields that return the business hours between two sets of dates in the format "h:nn".
What I would like to do is subtract the first field [HoursA] from the second [HoursB], but the expression [HoursA] - [HoursB] doesn't work like it would in excel. I have also tried DateDiff("n", [HoursA], [HoursB]), but this only works if either field is less than 24 hours.
Does anyone have a expression for subtracting these calculated fields e.g. 20:00 - 5:00 = 15:00 hours?
Regards
R
I have a query with two calculated fields that return the business hours between two sets of dates in the format "h:nn".
What I would like to do is subtract the first field [HoursA] from the second [HoursB], but the expression [HoursA] - [HoursB] doesn't work like it would in excel. I have also tried DateDiff("n", [HoursA], [HoursB]), but this only works if either field is less than 24 hours.
Does anyone have a expression for subtracting these calculated fields e.g. 20:00 - 5:00 = 15:00 hours?
Regards
R