This is my first time posting so please bear with me...
I have a spreadsheet with two columns containing date and time stamps and I need to calculate the hours elapsed between the two date/times excluding weekdays and holidays. I tried using the NETWORKDAYS formula but it only considered the dates and reported the results in days, but what I need is hours. Not business hours, just hours. So for example:
Column F Row 7 shows 5/18/2009 21:01
Column G Row 7 shows 5/20/2009 22:27
I need a formula that will consider date and time in each column and report the time elapsed in hours.
Any help or advice on composing my formula would be greatly appreciated!
I have a spreadsheet with two columns containing date and time stamps and I need to calculate the hours elapsed between the two date/times excluding weekdays and holidays. I tried using the NETWORKDAYS formula but it only considered the dates and reported the results in days, but what I need is hours. Not business hours, just hours. So for example:
Column F Row 7 shows 5/18/2009 21:01
Column G Row 7 shows 5/20/2009 22:27
I need a formula that will consider date and time in each column and report the time elapsed in hours.
Any help or advice on composing my formula would be greatly appreciated!