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
 - Facebook id verification time - Guide
 - Instagram message request - Guide
 - Fenix internet on bank statement - Guide
 - Ocarina of time rom - Download - Action and adventure
 
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....)