LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Calculating Time Elapsed in Excel

Hi Everyone,

How can I calculate the time elapsed between two given times?
For example if I input initial time and date as 20:00 on 03 Jan 06 and
final time and date as 05:00 on 05 Jan 06, I want to calculate the
number of hours elapsed. Moreover I am interested in whole numbers i.e.
8 hours and 31 minutes should round to 9 hours and 8 hours and 29
minutes should round to 8 hours. I need to multiply this time elapsed
with another constant quantity?

Any help would be appreciated.

regards

 
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
Calculating Elapsed Time Rosemary Excel Worksheet Functions 2 March 23rd 09 03:23 PM
Calculating elapsed time tele2002 Excel Discussion (Misc queries) 2 December 22nd 05 05:47 PM
Calculating Time elapsed bhomer Excel Worksheet Functions 1 November 21st 05 01:16 PM
Calculating elapsed time andoh Excel Worksheet Functions 5 November 17th 05 11:31 AM
Calculating a rate for elapsed time? Keith Excel Discussion (Misc queries) 8 May 18th 05 09:14 PM


All times are GMT +1. The time now is 10:16 AM.

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

About Us

"It's about Microsoft Excel"