MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How do I separate then total times in Excel 97


Posted by R Walker on October 16, 1999 1:12 AM

Hello, I'm fairly new to Excel (97), and have a good
but rather basic understanding of Excel, and am trying
to figure out how to get Excel to automatically sort
and then total numerous random times and then appropriately
place them into one of four categories as listed below.

6:01 AM-12:00 PM
12:01 PM-6:00 PM
6:01 PM-12:00 PM
12:00 AM-6:00 AM

Thanks very kindly for any help.


Posted by Chris on October 18, 1999 8:52 AM


You should be able to use something like this:

=IF(A1<0.25,1,IF(A1<0.5,2,IF(A1<0.75,3,4)))

This will break the list up into 4 shifts. You can then sort and subtotal on that column.

You can obviously change the numbering of the shifts if you need.

HTH,
Chris