Calculating hours between two points in time

  • Thread starter Thread starter John Pierce
  • Start date Start date
J

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.
 
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.
 
Back
Top