ExcelBanter - Time Formulas

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Time Formulas (https://www.excelbanter.com/excel-discussion-misc-queries/122002-time-formulas.html)

MuncieJeff

Time Formulas

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

mzehr

Time Formulas

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

MuncieJeff

Time Formulas

Thank You very much.

"mzehr" wrote:

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

All times are GMT +1. The time now is 06:00 AM.