2
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.
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:
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.
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (