Hello everyone...
I am trying everything and getting a tad bit no where.
I am trying to setup a START and END time.
Here is a brief example:
I enter in a start time in A1 (we will say 9:30 am)
I want to find out what time it will be when i manually enter given amount of total of time, so I enter into B1 the number 1.5 (1 hour and 30 minutes)
as you guessed it, C1 is where I want the new time to show, in this case I am expecting C1 to report back 11:00 am
I kind of understand about the =SUM(A1)+TIME(1,30,0) where the 1 & 30 will add 1:30 minutes so C1 would report back 10:00 am.
But the only info I have is basically A1+B1 I am trying to solve for C1
Thanks
Tony
I am trying everything and getting a tad bit no where.
I am trying to setup a START and END time.
Here is a brief example:
I enter in a start time in A1 (we will say 9:30 am)
I want to find out what time it will be when i manually enter given amount of total of time, so I enter into B1 the number 1.5 (1 hour and 30 minutes)
as you guessed it, C1 is where I want the new time to show, in this case I am expecting C1 to report back 11:00 am
I kind of understand about the =SUM(A1)+TIME(1,30,0) where the 1 & 30 will add 1:30 minutes so C1 would report back 10:00 am.
But the only info I have is basically A1+B1 I am trying to solve for C1
Thanks
Tony