September 14, 201213 yr I thought it would be easy to simply add 20 minutes to a time field by; Time ( Timetable_Hour; Timetable_Minute;"" )+20 With the calculation result being 'Time'. However, not to be. Had a look online but couldn't find anything. Could you please point me in the right direction. Thanks so much and have a great weekend.
September 14, 201213 yr Time fields hold time as seconds, so your calculation would have added 20 seconds to the time. You can add 20 minutes using one of these calculations: Time ( Timetable_Hour; Timetable_Minute; 0 ) + 20 * 60 Time ( Timetable_Hour; Timetable_Minute; 0 ) + Time ( 0 ; 20 ; 0 )
September 14, 201213 yr I thought it would be easy to simply add 20 minutes to a time field by; Time ( Timetable_Hour; Timetable_Minute;"" )+20 What are Timetable_Hour and Timetable_Minute? And where is the time field? Adding 20 minutes to a time field is indeed easy = Timefield + 1200
September 14, 201213 yr Author Aha. I am adding seconds, not minutes, That makes it very easy. Thanks so much and have a wonderful day!
Create an account or sign in to comment