Elapsed time Calc...over 30 days long...

S

SeanRinVA

B2 C2 D2
09/29/04 9:59 AM 11/30/04 05:23 PM 2 Days 08 Hours 02
Minutes

D2's formula is C2-B2.
D2's custom format is d "Days" hh "Hours" mm "Minutes"

I'd like this to correctly calculate. Later, I'd like to calculate
based on work hours (8am until 6pm), take out weekends and holidays.
I've tried to use Networkdays, but it has not come out correctly yet.
You can email me at SeanRinVA at gmail dot com

Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating elapsed days and hours 4
Calculate Transaction Time Over Days 3
Difference between dates and times 5
Formula for elapsed time 3
calculate time elapsed inbetween days 3
Format for Time Elapsed in Decimal 4
Allocate Time Range over each hour of the day? 1
subtracting date and time to find the difference between the two 2

Top