Format of Time to Start?

[Mitch]

Hi,

I'm trying to create a condition based on the time to start of event.

Looking at the format of the cell it says "h:mm:ss" but copy and paste values gives "0:03:45" for example when I thought it should be 0.002604 or something similar.

I've tried treating it as text and as a number and as a time but I can't get any of them to work.

Can anybody help please?

P.S. Gary, were you aware that the time to start field goes negative when the start is not "today".

[Ian]

Mitch .. the format you need is General, but the BA reformats the cell on each refresh, so you need to link another cell to the start time cell and change the format of that cell to General.

[Mitch]

I finally made my formula work.

I've had to treat it as a time format if it's bigger than 00:00:00 but as text when the figure goes negative.

Gary, is there anything that can be done about the negative 'time to start' figure if the event is on the next day?
I wouldn't imagine it's a problem for many, but if you bet on american sports a 12.05am kickoff shows as a negative time to start until after midnight.