News and Announcements icon

Dynamics 365 CommunityForums Sales forum diffinhours not showin...

Sales forum

Answered

diffinhours not showing in decimal values

(0) Share

Report

Report

Posted on by EKL

Hi ,

I want to get decimal values of hours between two datetime fields but diffinhours is returning only whole

eg 10.10 which is shown as 10 between two datetime fields.

10.40 shown as 11 between two datetime fields.

Thanks.

Categories:

All responses Img

All responses (4)

Answers Img

Answers (1)

Suggested answer

Abdul Wahab 12,070 Moderator on at

Like (0)

Report
RE: diffinhours not showing in decimal values

Hi EKL,

I have got one more solution for you. I hope you like it most.

Here is the screenshot of of the implemented solution

I created below columns to solve this problem:
Verified answer

Abdul Wahab 12,070 Moderator on at

Like (1)

Report

RE: diffinhours not showing in decimal values

Hi EKL,

If we are talking about calculated columns. I may say Yes but again this is my thought. Otherwise, you can go for Power Automate.
Suggested answer

EKL on at

Like (0)

Report

RE: diffinhours not showing in decimal values

Hello Abdul,

Thank you.

In that case we need a another field and is it a standard way of implementing??
Suggested answer

Abdul Wahab 12,070 Moderator on at

Like (1)

Report

RE: diffinhours not showing in decimal values

Hi EKL,

How about taking the difference in minutes and then converting it to hours using a formula? A number of hours = Number of minutes divided by 60.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 290,246 Super User 2024 Season 2

#2

Martin Dráb 228,041 Super User 2024 Season 2

#3

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans