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
I'm not exactly sure I know what your trying to say but you can
calculate time differences very easily. Lets say your start times are
from the cells A2 to A10 and your end times are B2 to B10. You want to
calculate end times - start times.
Go to the cell C2 and type =SUM(B2)-(A2)
After enteri
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"
Subject
On Tue, 2004-03-09 at 09:33, James&Rosemary Rutherford wrote:
> Chris,
> It depends on how you entered the times.
Yes.
> Excel stores dates and times as a number (whole number for the date, decimal
> portion for the time.)
Yes.
> e.g. 9th March 2004 6.25 am is represented by 38,055.268002778
>
4 matches
Mail list logo