On Monday 17 September 2007 09:59:12 Sudheer Satyanarayana wrote: > Hi Joseph, > > Thanks for your response. > > I'm sorry I did not understand what exactly is AC-AB. I have not > changed the format of column A and column B. When I enter time in > hh:mm format it defaults to time format. When I enter 02:15 and > hit enter, I see 02:15:00 AM. I would like to calculate the time > difference in minutes. > > I hope my question is clear. > > Joseph Nelson wrote: > > AC-AB in the AD column. Format column D in the same manner as > > B and C. Let me know if this helps. > > > > Thanks, > > > > Joe Nelson > > > > Sudheer Satyanarayana <[EMAIL PROTECTED]> wrote: > > Hi, > > > > I have a spreadsheet with two columns. Column A contains the > > start time and column B contains the end time. I enter data > > into these columns in the format hh:mm. In column C I would > > like to calculate the difference of column B and column A in > > minutes or hours. I'm using this spreadsheet for office > > productivity. > > > > How can I achieve this?
He probably meant B1-A1. The formula in C1 would look like this =B1-A1 -- http://24.197.142.167/ See the OpenOffice.org FAQ Microsoft users go to http://www.pclinuxos.com for a great user friendly Linux experience! --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
