- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Calculate time difference with respect to Date and given time in decimal format
Hello:
I tried to calculate tworking hours with the rest time given in decimal format with 1 = 60 min and .75=.75*60=45 min and again one emplyee starts work one day AM and another day with AM( mark with yellow colour). I got wrong result in my measure . Can some body help me to solve this problem?
here is the sample dataset:
Regards:
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I tried again and find the solution like
Step1: Calculated the time difference in times by using function DATEDIFF and VALUES
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I tried again and find the solution like
Step1: Calculated the time difference in times by using function DATEDIFF and VALUES
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Microsoft Fabric Community Conference 2025
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
Subject | Author | Posted | |
---|---|---|---|
11-03-2023 07:45 AM | |||
03-18-2024 11:08 AM | |||
05-03-2024 09:37 AM | |||
06-12-2024 10:08 AM | |||
03-29-2024 05:37 AM |
User | Count |
---|---|
113 | |
76 | |
56 | |
55 | |
43 |
User | Count |
---|---|
183 | |
120 | |
80 | |
67 | |
57 |