Assistance request - IF statement and adding Time
Closed
msfrandson
Posts
1
Registration date
Tuesday 6 March 2018
Status
Member
Last seen
7 March 2018
-
7 Mar 2018 à 12:59
hershmab Posts 3 Registration date Thursday 31 August 2017 Status Member Last seen 7 March 2018 - 7 Mar 2018 à 13:54
hershmab Posts 3 Registration date Thursday 31 August 2017 Status Member Last seen 7 March 2018 - 7 Mar 2018 à 13:54
Related:
- Assistance request - IF statement and adding Time
- Instagram message request - Guide
- Popcorn time apk - Download - Movies, series and TV
- Zelda ocarina of time rom - Download - Action and adventure
- Ps3 controller charging time - Guide
- More than 1 if statement excel - Guide
1 response
hershmab
Posts
3
Registration date
Thursday 31 August 2017
Status
Member
Last seen
7 March 2018
7 Mar 2018 à 13:54
7 Mar 2018 à 13:54
1) The most obvious problem is your assumption that adding the number 1230 to a date/time cell is the same as adding the time 12:30 - What it actually does is to add 1230 days to the existing date/time.
2) Similarly the starting value in C21 should be shown as "06:30" and should be formatted by Excel as a time
3) Your formula could be expressed more concisely using Excel's CHOOSE function in this fashion:
2) Similarly the starting value in C21 should be shown as "06:30" and should be formatted by Excel as a time
3) Your formula could be expressed more concisely using Excel's CHOOSE function in this fashion:
where the list of additions corresponds to the values of F21, i.e 1,2,3,4.....
=C21+ CHOOSE(F21,4:00:00,8:15:00....)