time of day

I'm using some data that came from an IVR system. Many of the numbers I am using are time intervals formatted as HH:MM:SS like speed of answer, length of call, etc. I need to sum these numbers and also get them to sum in a pivot table, but they will not. I have tried every format that...

Hello all, I wasn't sure if this could be done as a formula, but basically, I am looking for something that would return the cell value of "Good morning" from 1:00-12:00, good afternoon from 12:01-17:00, and good evening from 17:01 to 01:00. is there a simple way to do this? The reasoning...

Hello, I am working on a global schedule for technicians using Excel. I would like a way to have the color in the cell in front of the technician name to change based on the time of day. Also I would like for the cell in front the cell to show number of hours left until their work shift ends...

Hi, I work for a company that gets survey results from our customers. I am looking at all the data that is exported to excel in '03 and in the row where the time of the surveys show, I can not for the life of me figure a way to find the average. The format is mm/dd/yyyy hh:mm:ss am/pm - I want...

Data from a SQL database represents time of day as a string of x's when imported into Excel. With CLEAN, I found that noon is -0.5. This means that the calculation being used for noon is (24 * -0.5), or -12, meaning "go to the end of the 24 hour day, then go back half a day to noon." Similar...