subtract minutes from time
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
|