OK if you insist LOL

"Gord Dibben" wrote:

240 is equal to 3 hours?

At 80 minute hours maybe<g


Gord Dibben MS Excel MVP

On Sat, 14 Mar 2009 12:08:01 -0700, Pimamedic
wrote:

TY TY TY

Now how do I convert 240 to time format which in this case woudl be 3 hours

"Mike H" wrote:

hi,

And Another

select the date(s) in a column then

Data|Text to columns - Next - Next - Select Date - YMD

Finish

Mike

"Pimamedic" wrote:

How do I convert 20090228 to read as 02/28/2009 is there a format to do
this?? TY