I have an ususual problem in that I have two columns of time and I am trying to get the number of seconds in them. The way that my time format is setup is as follows:
In this example, the difference between the two times is 55 seconds.
Unfortunately, the raw data for my time is as above and is not in an easy format like 10:52:36 and 10:53:31. If it were, I could use one of two formulas like = (c1 - b1,"s") or = (c1 - b1) * 86400.
The problem with the data that I have is that I cannot get Excel to read the formatting of the time data that I have. It basically does not understand the values as a time value. Could someone please give me some suggestions on how to deal with my problem.
The last thing I want to do is to parse through my two columns and do the following:
Excel works in decimal numbers - you have sexagesimal.
Suggest you convert, for example using division and INT - or maybe integer division if using VBA. You can combine the elements (hours, minute, seconds) with the TIME worksheet function and do subtraction in the normal manner.