Convert Time
in [General]
|
From: Jim on 28 Jan 2010 16:16 Hello, In one cell I have the time showing (2:45:59 PM). In another cell I would like to input a formula that will convert the time into a text cell showing military time. Thanks in advance for the help.
From: Niek Otten on 28 Jan 2010 16:33 Depends on what you call "military time" Anyway, in the new cell, insert the formula: =A1 assuming that the original time is in A1 Then format custom as hh:mm:ss or hhmmss -- Kind regards, Niek Otten Microsoft MVP - Excel "Jim" <Jim(a)discussions.microsoft.com> wrote in message news:5A87A835-1AEE-4276-85DD-59C7152DBB91(a)microsoft.com... > Hello, > > In one cell I have the time showing (2:45:59 PM). In another cell I would > like to input a formula that will convert the time into a text cell > showing > military time. > > Thanks in advance for the help.
From: Jim on 28 Jan 2010 16:40 So how do I convert it into text? "Niek Otten" wrote: > Depends on what you call "military time" > > Anyway, in the new cell, insert the formula: > > =A1 > > assuming that the original time is in A1 > > Then format custom as hh:mm:ss or hhmmss > > > -- > Kind regards, > > Niek Otten > Microsoft MVP - Excel > > "Jim" <Jim(a)discussions.microsoft.com> wrote in message > news:5A87A835-1AEE-4276-85DD-59C7152DBB91(a)microsoft.com... > > Hello, > > > > In one cell I have the time showing (2:45:59 PM). In another cell I would > > like to input a formula that will convert the time into a text cell > > showing > > military time. > > > > Thanks in advance for the help. >
From: Niek Otten on 28 Jan 2010 16:43 =TEXT(A1,"hhmmss") -- Kind regards, Niek Otten Microsoft MVP - Excel "Jim" <Jim(a)discussions.microsoft.com> wrote in message news:004E198B-AB3A-4497-9635-48A599D2A1AB(a)microsoft.com... > So how do I convert it into text? > > "Niek Otten" wrote: > >> Depends on what you call "military time" >> >> Anyway, in the new cell, insert the formula: >> >> =A1 >> >> assuming that the original time is in A1 >> >> Then format custom as hh:mm:ss or hhmmss >> >> >> -- >> Kind regards, >> >> Niek Otten >> Microsoft MVP - Excel >> >> "Jim" <Jim(a)discussions.microsoft.com> wrote in message >> news:5A87A835-1AEE-4276-85DD-59C7152DBB91(a)microsoft.com... >> > Hello, >> > >> > In one cell I have the time showing (2:45:59 PM). In another cell I >> > would >> > like to input a formula that will convert the time into a text cell >> > showing >> > military time. >> > >> > Thanks in advance for the help. >>
|
Pages: 1 Prev: counting rows Next: Cannot open 2007 excel files(.xls) as email attachments on Win. Vi |