Hi,

I've tried two formulas, but I keep ending up with some negative numbers, which is impossible.

Here's one formula:

24*((NETWORKDAYS(F37,G37)-1)*(eT-sT)+MOD(G37,1)-MOD(F37,1)

eT is the end time (5:00 pm) and sT is the start time (9:00 am).

When I use that formula (or the other formula posted on this board), I end up with a negative time (hours) between these two dates:

3/24/13 11:51 AM 3/25/13 11:29 AM

The formula returns a result of -.38.

The formulas work with most instances, but there are a few dates where it returns a negative number, like the one above.

Thank you so much for any help!