LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2
Default Working with dates and time

I need to calculate the elapsed time in hours from data in 4 date and time
columns (date dd/mm/yyyy format and time in 24 hour format) e.g.

Start Date Start Time Stop Date Stop Time
10/12/2008 15:10 13/12/2008 12:50
11/12/2008 02:00 11/12/2008 16:30
11/12/2008 10:10 13/12/2008 09:00

I need to then be able to find the average elapsed time in hours.

Manually the solution for the above is:

69:40
14:30
46:50
Average elapsed time: 43:40

As I am not used to working with date and time fields, any help would be
much appreciated as I have several hundred lines of data and manually
calculating this would drive me nuts.

~John


 
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
Subtracting Dates to get total time work time excluding weekends Jon Ratzel[_2_] Excel Discussion (Misc queries) 2 January 31st 08 10:36 PM
Working with Dates [email protected] Excel Discussion (Misc queries) 2 July 5th 07 11:41 PM
Calculating time increments from dates during working hours S Davis Excel Worksheet Functions 0 October 24th 06 03:32 PM
Working with dates and time Ben Excel Discussion (Misc queries) 4 March 7th 06 10:00 PM
working with dates Pe66les Excel Worksheet Functions 3 August 25th 05 12:19 AM


All times are GMT +1. The time now is 10:50 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"