Subtract seconds from date VBA

1
votes

I would like to subtract a number of seconds from a date. I have two columns one that lists the date in the format D/M/YY HH:MM AM/PM and the other lists a number seconds. I want to do: 

07/28/15 12:08 AM - 60 = 07/28/15 12:07 AM

However if I subtract the two columns I get no value.

1
excelvba
possible duplicate of VBA Excel: Add one second to a time - eirikdaude
Tried to use Date - TIME(0;0;CELL) = , but this results also in the #VALUE! error - F1990

1 Answers

2
votes

date in A1, # of seconds in A2

=A1-A2/86400

86400 being 24*60*60 to convert seconds into decimals