Hi,

I'm very new to excel and trying to make myself a template with a timeline based on an Event and various times before the event.

I managed to achieve a working table but I have a problem as I work through midnight. i.e. If the event time is 01:00 and I need to take away 1:30, i want the table to display 23:30. at the moment it displays -0:30.

I'm using the current formula and the columns are formatted to time.

=D2-C3

Thanks for looking

Oggy