MariaAux Posted September 14, 2012 Posted September 14, 2012 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.
dansmith65 Posted September 14, 2012 Posted September 14, 2012 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 )
comment Posted September 14, 2012 Posted September 14, 2012 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
MariaAux Posted September 14, 2012 Author Posted September 14, 2012 Aha. I am adding seconds, not minutes, That makes it very easy. Thanks so much and have a wonderful day!
Recommended Posts
This topic is 4510 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now