Hi,
I've times values in couple of cells in the format HH:MM:SS...The cell has been formatted to text format....I would like to know how I can do some add and sub opearation on the cell...
Thanks
Hi,
I've times values in couple of cells in the format HH:MM:SS...The cell has been formatted to text format....I would like to know how I can do some add and sub opearation on the cell...
Thanks
Why have you formatted as text? You can add times if you leave them as a Number Format
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks