Assistance request - IF statement and adding Time
Closed
msfrandson
Posts
1
Registration date
Tuesday March 6, 2018
Status
Member
Last seen
March 7, 2018
-
Mar 7, 2018 at 12:59 PM
hershmab Posts 3 Registration date Thursday August 31, 2017 Status Member Last seen March 7, 2018 - Mar 7, 2018 at 01:54 PM
hershmab Posts 3 Registration date Thursday August 31, 2017 Status Member Last seen March 7, 2018 - Mar 7, 2018 at 01:54 PM
Related:
- Assistance request - IF statement and adding Time
- Popcorn time download - Download - Movies, series and TV
- Fenix internet on bank statement - Guide
- Submit request free fire - Guide
- Ocarina of time rom - Download - Action and adventure
- Free fire account transfer request - Guide
1 response
hershmab
Posts
3
Registration date
Thursday August 31, 2017
Status
Member
Last seen
March 7, 2018
Mar 7, 2018 at 01:54 PM
Mar 7, 2018 at 01:54 PM
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....)