I am pretty much a newbie to XL....
With that said here's the detail of what I'm trying to do:
We have driver routes which I use Maximum and Minimum to extract the beginning and ending times for the route (times are in seconds after midnight). I figure out the total hours for each route, subtracting out any breaks the driver took during the day. Here's my formula which does work correctly:
((Maximum ({Events.ActualDepartTime}, {EventStrings.EvStrName}) -
Minimum({Events.ActualDepartTime},{EventStrings.EvStrName})) / 3600) - Sum ({@breaks}, {EventStrings.EvStrName})
I've placed this in the EventStrings.EvStrName group header. Ok, so that all works but now I need to total up the hours for each route to get the total hours for a day. Apparently one can't sum a sum and it looks like using variable is the way to go. I've tried setting this up but having trouble. May I get some assistance? Thanks much. MJS
With that said here's the detail of what I'm trying to do:
We have driver routes which I use Maximum and Minimum to extract the beginning and ending times for the route (times are in seconds after midnight). I figure out the total hours for each route, subtracting out any breaks the driver took during the day. Here's my formula which does work correctly:
((Maximum ({Events.ActualDepartTime}, {EventStrings.EvStrName}) -
Minimum({Events.ActualDepartTime},{EventStrings.EvStrName})) / 3600) - Sum ({@breaks}, {EventStrings.EvStrName})
I've placed this in the EventStrings.EvStrName group header. Ok, so that all works but now I need to total up the hours for each route to get the total hours for a day. Apparently one can't sum a sum and it looks like using variable is the way to go. I've tried setting this up but having trouble. May I get some assistance? Thanks much. MJS