paddysheeran
06-03-2011, 04:12 AM
Hi All,
I need to be able to calculate the time difference between two dates. For example:
17/05/2011 12:04 and 01/06/2011 00:00
I only need to calculate the time elapsed between 8am-6pm Monday to Friday between these two dates. I think the forumla may need to use Network Days or the Weekday function but not sure which. Does anyone have a solution?
thanks,
Padraig.
I need to be able to calculate the time difference between two dates. For example:
17/05/2011 12:04 and 01/06/2011 00:00
I only need to calculate the time elapsed between 8am-6pm Monday to Friday between these two dates. I think the forumla may need to use Network Days or the Weekday function but not sure which. Does anyone have a solution?
thanks,
Padraig.