am trying to get difference between to given date and time. Am using calworkdays

nimishan over 10 years ago

am trying to get difference between to given date and time. Am using calworkdays function to acheive this however the output the output is given as number i want to display in the form of days ,hours and minutes format.Please give suggestion....

Discussion posts and replies are publicly visible

Top Replies

Malathi over 10 years ago +1
Certified Lead Developer

You can try the below expression which returns output as days,hours and minutes. with(a:ri!date2-ri!date1,b:split(a,":"),b[1]&" days,"&b[3]&" hours,"&b[4]&" minutes")

Parents

0 bragadeeshp over 10 years ago

thanks for your response. we understand the aboove expression will display the difference between 2 date & time in Days / Hours / Mins format ..

However, we want to display the net working time between 2 date and time variables. So we can use either calworkdays() or calworkhours(). e.g. calworkhours(date1, date2, "Calendar")

But both these funtions returns numeric output. is there a better way to display the Numeric output into Days / Hours / Mins format ?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 bragadeeshp over 10 years ago

thanks for your response. we understand the aboove expression will display the difference between 2 date & time in Days / Hours / Mins format ..

However, we want to display the net working time between 2 date and time variables. So we can use either calworkdays() or calworkhours(). e.g. calworkhours(date1, date2, "Calendar")

But both these funtions returns numeric output. is there a better way to display the Numeric output into Days / Hours / Mins format ?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data