Announcements
The way to achieve your own success is the willingness to help somebody else. Go for it!
cancel
Showing results for
Did you mean:
Not applicable

## Converting hours to min

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.

1 Solution

Accepted Solutions
MVP

You want this?

`= hour('12:50:00') * 60 + minute('12:50:00')`

5 Replies
Not applicable
Author

use this

=

SubField('12:50:00',':',1) *60 + SubField('12:50:00',':',2)

SubField('12:50:00',':',1) *60 + SubField('12:50:00',':',2)

Not applicable
Author

Hello again,

see the attached example.

I played arround a little bit with days, hours, minutes and so on.

Good luck!

Rainer

MVP

You want this?

`= hour('12:50:00') * 60 + minute('12:50:00')`

Specialist

Hi, this helps too

`interval('12:50','m')`

returns 770 = 12*60 + 50

Rgds

Champion III

Yet another way:

interval#('12:50','hh:mm')*24*60

Community Browser