Calculating hours between two points in time

[John Pierce]

I need a way of calculating the length of events
at work that start and end at various times,
sometimes spanning several days. I have been
working with a formula using NETWORKDAYS
that I got on Chip Pearson's site and I get good
results for most events but the problem is that we
are open on Saturday and NETWORKDAYS
eliminates those hours. I do want to eliminate
Sundays and Holidays so I was wondering if
there was a custom worksheet formula or VBA
procedure that could accomodate a six-day work week.

 

[JohnDK]

why not just subtract end time from start time and format as [h:mm:ss]
to get hours,minutes and sec.
Or take result of subtraction and multiply by 1440 and divide by 60.
Format as general and get decimal hours.