Time in conditional formulas

Last Edited By Krjb Donovan
Last Updated: Mar 05, 2014 09:58 PM GMT

Question

Excel Spreadsheet

I have a spreadsheet and column C is formatted as time (HH:MM:SS). I then take the average of the times in column c. My problem is I need to create a conditional formula where the I assign a rating value (c16) to the average time (c15). Is one able to either use HH:MM:SS in a conditional formula or is there a way to convert the HH:MM:SS to just secs. The current formula I have in there would work if I was able to convert it to seconds. Any help would be greatly appreciated.

Answer

If you have the data in time format, you can convert it to seconds by using a formula like: =A1*86400 86400 is the number of seconds in a day, andstores time values as numbers, with 1 being 24 hours. This multiplication will give you the number of seconds for a cell.

Advertisement

©2020 eLuminary LLC. All rights reserved.