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 sivananthag over 8 years ago

endDateTime - startDateTime gives the difference in time, but i need only work hours & minutes to be returned. for example if i give startDatetime as 10 Sept 2015 3.10 pm and endDateTime as 11 sept 2015 2.00 pm, I need to get the work hours and mins as 6 hrs 50 mins for a work day of 9am to 5 pm. due to this reason , I have used calworkhours, but it returned integer value as 6 hours.
thanks
Jhothi
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 sivananthag over 8 years ago

endDateTime - startDateTime gives the difference in time, but i need only work hours & minutes to be returned. for example if i give startDatetime as 10 Sept 2015 3.10 pm and endDateTime as 11 sept 2015 2.00 pm, I need to get the work hours and mins as 6 hrs 50 mins for a work day of 9am to 5 pm. due to this reason , I have used calworkhours, but it returned integer value as 6 hours.
thanks
Jhothi
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data