subtract minutes from time

[Guest]

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.)

 

[Pete_UK]

You have to divide the minutes by 60 and by 24 in order to subtract
them from a time-formatted value. i.e. if you have 8:15 am in A1 and 15
in B1 try this in C1:

=A1-B1/60/24

and format the cell as time.

Hope this helps.

Pete

 

[Peo Sjoblom]

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

 

[RONELO]

Need help on this. subtract days and hour and convert it to minutes.
example:
A1 = April 1, 2013 6:30 AM
B1 = April 2, 2013 5:30 AM
Answer C1 = A1-B1 = 33,120 Minutes.

Pls. help me on this!