ExcelBanter - Need to add semi colon in time numbers

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

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

- - Need to add semi colon in time numbers (https://www.excelbanter.com/excel-discussion-misc-queries/262732-need-add-semi-colon-time-numbers.html)

RustyB

Need to add semi colon in time numbers

I need a formula for taking a time number like 1435 and making it 14:35. I know there is a simple way to do it but I can't figure it out. Any help would be greatly appreciated.

Luke M[_4_]

Need to add semi colon in time numbers

=TIMEVALUE(LEFT(A2,2)&":"&RIGHT(A2,2))

Format the cell then as desired.

--
Best Regards,

Luke M
"RustyB" wrote in message
...

I need a formula for taking a time number like 1435 and making it 14:35.
I know there is a simple way to do it but I can't figure it out. Any
help would be greatly appreciated.

--
RustyB

David Biddulph[_2_]

Need to add semi colon in time numbers

=--TEXT(A1,"00\:00") and format as time to suit.
--
David Biddulph

"RustyB" wrote in message
...

I need a formula for taking a time number like 1435 and making it 14:35.
I know there is a simple way to do it but I can't figure it out. Any
help would be greatly appreciated.

--
RustyB

All times are GMT +1. The time now is 10:11 AM.