ExcelBanter - Time Format

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

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Time Format (https://www.excelbanter.com/new-users-excel/194327-time-format.html)

Dinesh

Time Format

-53323.9904390046

Hi can you please help me how to change this to time format

HH:MM:YY AM/PM

Danny Seager

Time Format

What Date/Time should that value actually be?

"Dinesh" wrote:

-53323.9904390046

Hi can you please help me how to change this to time format

HH:MM:YY AM/PM

All times are GMT +1. The time now is 09:49 AM.