I have a calculated field on a report page:
Datediff(minute,[@field:Start_Time], [@field:End_Time])
This calculates the number of minutes between the start and end time, but I want it to show up at total hours, as in 3.75 hours. I updated it like this:
Datediff(minute,[@field:Start_Time], [@field:End_Time])/60 but it gives me a 3 only for an answer.
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
Barbie
I have a calculated field on a report page:
Datediff(minute,[@field:Start_Time], [@field:End_Time])
This calculates the number of minutes between the start and end time, but I want it to show up at total hours, as in 3.75 hours. I updated it like this:
Datediff(minute,[@field:Start_Time], [@field:End_Time])/60 but it gives me a 3 only for an answer.
Link to comment
Share on other sites
1 answer to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.