Subtract date/time and get elapses days, hours, minues, etc

[SRGsMom]

I'll try to be very percise here, this is what I want a forumal to do in excel and I'm having some trouble.

Assuming that a workday is from 8:30am to 5:00pm. (also need to not calcualte Saturday and Sunday but this example doesn't show it).


Wednesday, 7/18/07 at 4:00pm (minus) Friday, 7/20/07 at 9:00am (should equal) 10 hours or 1 day, 1 hour and 30 minutes.

Basically what I want to do it determine how much work time has elapsed from the time a message was left on voicemail to the time that someone picks that message up. We only want to assume that a message can be retrieved duruing business hours but a message can be left at anytime!

This is a project on a time crunch!!! Any help is appreciated and I will be continuning to look for help!

 

[barry houdini]

Barry, as I understand it the message can be received at anytime, during, or outside of working hours

Thanks arthur,

Yes, I realised that belatedly hence my second formula above. As I say, although it doesn't explicitly say so on his website, Chip's formula will only work correctly when both dates are within working hours