LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8
Default Counting Time

How can I count, in hours; time elapsed in the form dd/mm/yyy hh:mm between
two dates and times and not include none working days?

i.e 08/06/2007 10:00 to 11/06/2007 09:00 should be 23 hours.

I use NETWORKDAYS frequently and am tring to figure something out along
those lines, but that only returns a whole number and I can't get it to break
down into hours.

Any advice would be very much appreciated.

Thanx
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Counting by combined start and end time monger Excel Discussion (Misc queries) 2 February 11th 06 01:23 AM
A Function for Counting Since Last Time Mickie Excel Worksheet Functions 3 June 12th 05 04:49 PM
A Function for Counting Since Last Time [email protected] Excel Worksheet Functions 1 June 9th 05 07:31 PM
counting time slots Nick Excel Worksheet Functions 1 March 11th 05 01:12 PM
Counting Cells with time value Anthony Excel Discussion (Misc queries) 2 February 9th 05 08:55 PM


All times are GMT +1. The time now is 06:36 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"