Change Number to Time
Glad they did -I do check them first :)
Steve
On Wed, 31 Jan 2007 16:06:59 -0000, Diane Walker wrote:
Thank you very much, Steve. Your instruction works!!!
"SteveW" wrote in message
news:op.tm0y63s8evjsnp@enigma03...
A2 = 100
A3 = 90 etc etc.
B2 = A2/60/24
Format B2 as hh:mm
Steve
On Wed, 31 Jan 2007 15:29:58 -0000, Diane Walker
wrote:
We are running Excel 2003. I exported data into Excel. This data is a
numeric field. For example, I would like to convert the number 100 to 1
hour 40 minutes; number 90 to 1 hour 30 minutes, etc. Is there a way to
set
it up in Excel? Thanks.
|