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?
--
With Warm Regards,
Sudheer. S
http://www.binaryvibes.co.in
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
