[ad_1]
If I have a calculated field (fieldname111) with the formula – cdate(fieldname109, ‘hh:ii’)
where fieldname109 is a date field with only time input selected, how do I add any number in another number field = fieldname110 to the time in – fieldname111?
I tried cdate(fieldname109+fieldname110, ‘hh:ii’) but the result is wrong.
fieldname109 = date field with time only
fieldname111 = cdate(fieldname109+fieldname110, ‘hh:ii’)
fieldname220 – a number field.
Is it also possible to show ‘am or pm’ in the calculated fields?
Thank you for your help.