Hi all,

I am at wits end to create a number pattern to replicate 24h time.

I require the format to be 'general' and the pattern look like (correctly formatted time in brackets):

001 (00:01), 002 (00:02),...059 (00:59), 100 (01:00),...2259 (22:59), 2300 (etc), 2301,...2359, 2400

I am positive that a simple formula will do the trick, yet I fall down in part where it skips from the end of one hour to the beginning of the next.

Any insights would be appreciate!