Need to add semi colon in time numbers
in [General]
|
From: RustyB on 29 Apr 2010 13:58 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
From: Luke M on 29 Apr 2010 15:17 =TIMEVALUE(LEFT(A2,2)&":"&RIGHT(A2,2)) Format the cell then as desired. -- Best Regards, Luke M "RustyB" <RustyB.61f89b5(a)excelbanter.com> wrote in message news:RustyB.61f89b5(a)excelbanter.com... > > 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
From: "David Biddulph" groups [at] on 29 Apr 2010 19:49 =--TEXT(A1,"00\:00") and format as time to suit. -- David Biddulph "RustyB" <RustyB.61f89b5(a)excelbanter.com> wrote in message news:RustyB.61f89b5(a)excelbanter.com... > > 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
|
Pages: 1 Prev: VLOOKUP with multiple look-up values Next: Excel macro deployment |