| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to do a formula counting the number of hours between 2 times?
We have some employees who work during a time which has a different hourly
rate than their usual rate. How can we do a formula that counts the number of hours between 11 PM and 6 AM? The cells it would be looking at are coming from an input log's cells that are formatted like this- 11:00 PM. We know how to make it count all hours worked, but we want to say "if there are hours between 11 PM and 6 AM, tell us how many there were. Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| counting the number of times shown | Excel Worksheet Functions | |||
| Counting number of times a value occurs | Excel Discussion (Misc queries) | |||
| Counting the times a number appears | Excel Discussion (Misc queries) | |||
| Calculate number of hours between dates and times excluding Weekends | Excel Discussion (Misc queries) | |||
| number of hours between two date/times | Excel Discussion (Misc queries) | |||
Threaded Mode
