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 entering this the difference should come up. You can then go to
the bottom right corner of the cell and the cursor should change.
Click and hold dragging down to C10 and it will do the other
calculations for you.
Hope this helps a little
Ruben A. Franke
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
