Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Is it possible to show convert hours into minutes by adding the minutes to it. Like if it is 12:50:00. I want to convert the 12hrs to minutes and add with the 50 minutes.
You want this?
= hour('12:50:00') * 60 + minute('12:50:00')
use this
=
SubField('12:50:00',':',1) *60 + SubField('12:50:00',':',2)
Hello again,
see the attached example.
I played arround a little bit with days, hours, minutes and so on.
Good luck!
Rainer
You want this?
= hour('12:50:00') * 60 + minute('12:50:00')
Hi, this helps too
interval('12:50','m')
returns 770 = 12*60 + 50
Rgds
Yet another way:
interval#('12:50','hh:mm')*24*60