Hi Oggy
D2 = Actual Time: 01:00
C3 is the time you wish to subtract
D2: 01:00
C3: 1:30
There a few ways, here are a couple.
1: =MOD(D2-C3,1)
2: =(D2+1)-C3
Kevin
Quote:
Originally Posted by OggyAv8er
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
|