hi, i have
=TIME(LEFT(F17,FIND("h",F17)-1),RIGHT(F17,2),0)
which gives a time in the format 9:30PM, or 10:30AM etc.
How would i change the formula to give me a time minus 15 mins
Eg, if the above formula gave me 8:45PM, i would want it to show 8:30PM
Regards, jamie
Bookmarks