Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is it possible to calculate integrals with Excel? | Excel Worksheet Functions | |||
Excel should calculate exponentials properly (right to left) | Excel Worksheet Functions | |||
How Excel & ACCPAC 6.1 calculate formulas???? | Excel Worksheet Functions | |||
CALCULATE HOURS WORKED | Excel Discussion (Misc queries) | |||
How do you calculate the nth root of a number in Excel 2003? | Excel Worksheet Functions |