Hello people of talent and knowledge. I hope one of you can help.
I have a sheet, into column N of which, I will be pasting a ‘time’. As pasting continues down the column, the time will vary, increasing or decreasing but only by the full hour. It will be formatted as “09:00” for example.
I would like each cell in column M to take the time in the related cell in column N (i.e. M2 to ‘see’ N2) return it, add 1 hour to it and return the time formatted as “09:00 – 10:00”.
Re: Adding time to create cell with 2 hyphenated times in it
Hello,
From your description, it looks like you are dealing with text or labels ... not actual times or numbers ...
If it is the case, you can test following formula in cell M2:
Hope this will help
Re: Adding time to create cell with 2 hyphenated times in it
TGry that again..
[ATTACH=CONFIG]73670[/ATTACH]
Re: Adding time to create cell with 2 hyphenated times in it
Try this
=IF(N2="","",TEXT(N2,"hh:mm")&" - "&TEXT(N2+1/24,"hh:mm"))
M2 should be formatted as General
Re: Adding time to create cell with 2 hyphenated times in it
Oh! my ***!
Hours, trying everything I knew or thought might work.
Obviously I don't know enough.
KjBox does.
My Grandchildren will thank you in the future as I do now.
From one VERY pleased member.
Re: Adding time to create cell with 2 hyphenated times in it
You're welcome.
Don’t have an account yet? Register yourself now and be a part of our community!
