Chris,
It depends on how you entered the times.
Excel stores dates and times as a number (whole number for the date, decimal
portion for the time.)
e.g. 9th March 2004 6.25 am is represented by 38,055.268002778
The time is a decimal of a day. You will have to convert the times entered
to decimal of a day, then you can tak one from the other (again this will be
decimal of a day which will have to be converted back to minutes or hours)
Regards
James Rutherford
----Original Message Follows----
From: Chris Burton <[EMAIL PROTECTED]>
To: "WAMUG Mailing List" <[email protected]>
Subject: times in excel
Date: Mon, 8 Mar 2004 06:04:02 +0800
Hi muggers
I have a quick query regarding time in excel.
Without thinking in a previous life, I have coded all the times of sightings
etc as straight numeric in excel and had some notion of being able to
convert to a time field later. I have tried reformatting the cells, but that
converts all numbers to zero. Arrrrrrhhh.
Im wanting to calculate a time difference between start and end times.
Simple?
Can someone with real excel experience give me some help?
regards
chris
-- The WA Macintosh User Group Mailing List --
Archives - <http://www.wamug.org.au/mailinglist/archives.shtml>
Guidelines - <http://www.wamug.org.au/mailinglist/guidelines.shtml>
Unsubscribe - <mailto:[EMAIL PROTECTED]>
WAMUG is powered by Stalker CommuniGatePro
_________________________________________________________________
Get Extra Storage in 10MB, 25MB, 50MB and 100MB options now! Go to
http://join.msn.com/?pgmarket=en-au&page=hotmail/es2
