ExcelBanter - Entering hour minute only 'now' in Excel (without day/date)

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

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

- - Entering hour minute only 'now' in Excel (without day/date) (https://www.excelbanter.com/excel-discussion-misc-queries/1989-entering-hour-minute-only-now-excel-without-day-date.html)

Ian

Entering hour minute only 'now' in Excel (without day/date)

How to change Time now function to give only Hour/minute time 'now' in Excel

Frank Kabel

Hi
just format the cell with the custom format
hh:mm

--
Regards
Frank Kabel
Frankfurt, Germany
"Ian" schrieb im Newsbeitrag
...
How to change Time now function to give only Hour/minute time 'now' in
Excel

All times are GMT +1. The time now is 03:27 AM.