ExcelBanter - convert time

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - convert time (https://www.excelbanter.com/excel-programming/317011-convert-time.html)

gareth

convert time

I have 09:30 in cell C35 (which is a value of 0.39583333).

I need to get 09:30 into cell G35 as text.

Any suggestions gratefully received.

Gareth

Frank Kabel

convert time

Hi
=TEXT(A1,"hh:mm")

--
Regards
Frank Kabel
Frankfurt, Germany

"gareth" schrieb im Newsbeitrag
...
I have 09:30 in cell C35 (which is a value of 0.39583333).

I need to get 09:30 into cell G35 as text.

Any suggestions gratefully received.

Gareth

All times are GMT +1. The time now is 11:01 PM.