Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Bobbi Prochnow [MSFT]
 
Posts: n/a
Default How do I calculate hours in Excel

Hi-
I found some instruction using the Help files. Go into MS Excel, choose the
-?- (Help icon). Search using the word 'hours'. In the results, there is an
article called 'Calculate the difference between two times' (Help Date
and Time Formulas)

Hopefully you can find what you are looking for here. An excerpt reads:
++++++++++

Calculate the difference between two times

Let's say you want find out how long it takes for an employee to complete an
assembly line operation or a fast food order to be processed at peak hours.
There are several ways to calculate the difference between two times.

What do you want to do?
- Present the result in the standard time format (hours : minutes : seconds)
- Present the result in a total based on one time unit (120 minutes)


--
**This posting is provided 'AS IS' with no warranties and confers no rights.**


"Dragonrana" wrote:

I have a start date and an end date.What I need is to give the difference in
hours? How do I do that?

i.e. 9:00AM (Start Date)
12:00 PM (End Date)

Result : 3 hours

Thanks.

Reply
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
Is it possible to calculate integrals with Excel? Francesco Excel Worksheet Functions 6 April 2nd 23 08:56 PM
Excel should calculate exponentials properly (right to left) expatrie Excel Worksheet Functions 5 April 26th 06 08:34 AM
How Excel & ACCPAC 6.1 calculate formulas???? Bass Mama1 Excel Worksheet Functions 1 February 9th 05 03:25 PM
CALCULATE HOURS WORKED Calculation of hours worked. Excel Discussion (Misc queries) 3 January 20th 05 06:01 PM
How do you calculate the nth root of a number in Excel 2003? William Excel Worksheet Functions 2 November 17th 04 04:19 PM


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