Time Log Data in Excel
What is the difference between "Hours" and "Hours (Fractional)" data.
0
Folllowing List for Post: Time Log Data in Excel
[this list is visible for admins and agents only]
Hi Sachinam, that's a great question, thanks for posting it here! "Hours" show the traditional representation of time, i.e. in hours and minutes. For example, 0.10 is equal to 10 minutes.
"Hours (Fractional)" show minutes as a fraction of an hour. For example, 10 minutes divided by 60 minutes = 0,17. Fractional hours can be helpful for further calculations in Excel if needed. Does this help? Let me know if you have any other questions!
How do I get fractional hours to show in my Excel exported file?
Hi Bien thanks for your post!
Once fractional hours have been captured in the task, the Excel export should be showing this information.
Is the issue that this column in Excel is empty or missing? Once I hear back from you, I'll raise a ticket to our Support Team to run through some troubleshooting with you 👍👍