help
help
A1 + A2 or something similar.
The addition should work but you would want to ensure the cell format
(number) displays what you want it to. Try going to format>cells...
click on the number tab and go to Custom. In the box, type [H]:mm
Be sure to put the square brackets around the H.
You see if, say you add 21:00 to 09:00, The default would generally show
06:00 as the answer - this is because what you don't see is that it is 06:00
+ 1 day - you would have to change the format to include date to see this
difference.
I hope this is clear enough - my english is getting ropey!
PS You may want to consider giving us more info next time you post.
Basil
"Wes" wrote:
> help
=A1+A2
as simple as that, format the result cell as [h]:mm
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Wes" <[email protected]> wrote in message
news:[email protected]...
> help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks