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.**
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