ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   How do I calculate hours in Excel (https://www.excelbanter.com/new-users-excel/53052-re-how-do-i-calculate-hours-excel.html)

Bobbi Prochnow [MSFT]

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.



All times are GMT +1. The time now is 05:56 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com