See Chip Pearson's excellent commentary on time forumlas

http://www.cpearson.com/excel/datearith.htm

hth

"MuncieJeff" wrote:

I need to know the formula to make cell (A3) Display what is in (A1) - 1 hr.

A1= 5:30 PM, A3 needs to display 4:30 PM