hi, i have a workbook that can have up to ten sheets open, all except a few with the name: time (in the format of 12h54, etc followed by text) for example, one sheet may be called "20h24 jamies sheet", but the sheets name is populated by web data and so i do not know the name until i open it, other than the time which is always at the beginning. i want any sheets that are open with the name starting with a time (a few do not) to have cell A45 to equal a 1 if the computers clock is equal or greater than the time at the beginning of the sheets name. if the computers clock is before the time at the beginning of the sheets name, i want A45 to equal a 0 (zero)

This is made all the more difficult, as the time on the sheets name is displayed as five digits, ie 12h45 unless it is the small hous of the morning, when it is three digits, ie 1h45.

I have tried using formulae and cant crack it, due to me being unable to get the clock and sheet name in the same format to be recognised as equal (the sheet name comes up as text form when displayed in a cell and the clock when displayed in a cell is in numerical form. i think it is possible, but i would have to reformat certain cells on each sheet as i open. I think!)

I was hoping one of you clever vba people may be able to help me out

Regards, jamie