Military Time
in [General]
|
Prev: I cannot view my e-mail
Next: Flexgrid in Access?
From: Max on 23 Feb 2005 16:27 How can I change the time from millitary time (0900) to 9 or (0925) to 9.25. Each one of these are in one feild.
From: Carole O on 23 Feb 2005 16:51 Hi, Max If 09:15 was in C1, the formula in D1 would read =C1*24. But -- the answer would not be 9.15, it would be 9.25 (15 minutes = 1/4 hour = .25 (1/4 of 100). You'll notice that I entered the colon between 09 and 15. I think you would have to format the military time to [hh]:mm (Format Cell Custom) in order for this to work. HTH, Carole O "Max" wrote: > How can I change the time from millitary time (0900) to 9 or (0925) to 9.25. > Each one of these are in one feild.
From: James Hahn on 23 Feb 2005 17:34 Divide the value into hours and minutes, and use the TimeSerial function to convert these values to a time t = TimeSerial( Int( v / 100 ), v - 100 * ( Int( v / 100 ) ), 0 ) -- "Max" <Max(a)discussions.microsoft.com> wrote in message news:81B3D6E1-5D6B-4F72-9895-F90C22335E79(a)microsoft.com... > How can I change the time from millitary time (0900) to 9 or (0925) to > 9.25. > Each one of these are in one feild.
From: Joseph Meehan on 23 Feb 2005 17:29 Max wrote: > How can I change the time from millitary time (0900) to 9 or (0925) > to 9.25. Each one of these are in one feild. What is the filed type to begin with? Text, number (what kind) etc. -- Joseph Meehan 26 + 6 = 1 It's Irish Math
From: Max on 24 Feb 2005 16:15
the feild type is TXT. "Joseph Meehan" wrote: > Max wrote: > > How can I change the time from millitary time (0900) to 9 or (0925) > > to 9.25. Each one of these are in one feild. > > What is the filed type to begin with? Text, number (what kind) etc. > > -- > Joseph Meehan > > 26 + 6 = 1 It's Irish Math > > > |