I am a bit lost…I have a start time field and number of hours field (sum field from a connected table) . I want to show a finish time by adding the number of hours to the start time but i cant get it to work.
I have this formula: DATE_FORMAT(ADDTIME({Start Time},{Hours}), ‘%I:%i %p’)
but this is just outputting the start time without adding the number of hours
Without testing this, I have a quick idea you could try.
The ADD TIME function adds seconds, so you could convert your Hours into seconds and see if that works?
DATE_FORMAT(ADDTIME({Start Time},({Hours}*60*60)), ‘%I:%i %p’)
I’m not sure if this will work, but you can try?
Create two fields start time and end time, then use the date formula to subtract the end time from start time.
