Time Function in Excel

Yahoo Archive
1
I just used the time( ) function and it returned "normal time."

You may want to check the format for the cell. I just changed it to
military time by changing the format.


Edward F. Fox, Jr., CPA
Controller
Maxson Automatic Machinery Company
Phone: 401-596-0162 x110
Fax: 401-596-1050
www.maxsonautomatic.com


-----Original Message-----
From: Juliet Martin [mailto:jmartin@...]
Sent: Wednesday, June 25, 2003 11:17 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Time Function in Excel


I am digging for a time function that will convert military time into
"normal" time in excel. Does anyone know how to do this?

TIA,

Juliet


Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/



[Non-text portions of this message have been removed]
2
I am digging for a time function that will convert military time into
"normal" time in excel. Does anyone know how to do this?

TIA,

Juliet