Hi I am using calworkhours(start_datetime, end_datetime) function to

sivananthag over 8 years ago

Hi

I am using calworkhours(start_datetime, end_datetime) function to get the workhours Number(Integer) between two datetime ( timestamps). It returns only the integer. but need the result to be with more precision - hours & minutes as decimal. for example 4 hrs 30 mts to be returned as 4.50. Is there any function in Appian to return work hours with the precision of minutes ( as decimal value)?

thanks
Jhothi

Discussion posts and replies are publicly visible

Parents

0 Stefan Helzle
A Score Level 3
over 8 years ago

Depending on how calworkhours works you could calculate the minutes part on its own. "minute(end) - minute(start)" should give you some value. Dividing 60 by that value gives you a fraction of an hour which you can add or subtract from the hour value calworkhours gives you.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Stefan Helzle
A Score Level 3
over 8 years ago

Depending on how calworkhours works you could calculate the minutes part on its own. "minute(end) - minute(start)" should give you some value. Dividing 60 by that value gives you a fraction of an hour which you can add or subtract from the hour value calworkhours gives you.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data