Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I want to calculate this difference in the hours of this information.
What is formula for calculation?
(ready time) - (notification time) = dd:hh.mm:ss
26.7.2017 8:41:57 - 26.7.2017 11:30:47 = dd:hh.mm:ss
time stamp style
Valmistumisaika - reagointiaika
May be this
Interval([ready time] - [notification time], 'D:hh:mm:ss')
May be this?
Interval(Date(Date#([ready time], 'DD.MM.YYYY hh:mm:ss'), 'DD-MM-YYYY hh:mm:ss') - Date(Date#([nontification time], 'DD.MM.YYYY hh:mm:ss'), 'DD-MM-YYYY hh:mm:ss'), 'DD:hh:mm:ss')
try this
interval(date1-date2,'hh')
thanks Sunny Tawlar this works very well
Br Kalle