Do you have 2 values in 2 different cells both formatted as time where one
is 08:15 and the other is 00:15? If so just subtract

= A2 - A3

where A3 is 00:15 and A2 is 8:15


if A2 is 8:15 and A3 is 15 use

=A2-(A3/1440)


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"holtonh179" wrote in message
...
What is the syntax for subtracting 15 minutes from 8:15 a.m.? (I want the
calculated end result to be 8:00 a.m.)