| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Find Min Time taking 24hrs into account
Hi all,
I am using to schedule arrivals/departures. In cell J3 i am look for a formula to find the earlier time in column F, these times in column F occure both before and after midnight ie. 19:30 is earlier than 01:00 in terms of a arrivals for a night shift. I need a formula to find the earliest time in the list taking this into account, min does not work as it sees 00:30 as earlier than 21:30 for example. Any help would be much appreciated. Thanks Kiktuo |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Autofilter COUNTA formula not taking into account hidden cells | Excel Discussion (Misc queries) | |||
| Taking in account additional rows | Excel Discussion (Misc queries) | |||
| How to calculate a person's age taking into account their birthda. | Excel Worksheet Functions | |||
| repeat formulae taking into account previous column's info? | Excel Discussion (Misc queries) | |||
| Date difference taking into account weekends. | Excel Worksheet Functions | |||
Threaded Mode
