Geekzone: technology news, blogs, forums
Guest
Welcome Guest.
You haven't logged in yet. If you don't have an account you can register now.


Sparky787

69 posts

Master Geek
+1 received by user: 2


#272847 20-Jul-2020 09:33
Send private message

Hi Team,

 

I have an export from LiveChat on Agent Performance and I am trying to get the Accepting Time/Not Accepting time to display in HH:MM 

 

Currently the HH component is displaying correctly, but the minutes have been converted into a number format.

 

Here is the screenshot of what it looks like in LiveChat:

 

 

Here is how it exported into Excel:

 

 

Any ideas or suggestions in the first direction is greatly appreciated. 

 

 





Sparky 


Create new topic

This is a filtered page: currently showing replies marked as answers. Click here to see full discussion.

jamesrt
1663 posts

Uber Geek
+1 received by user: 942

ID Verified
Trusted
Lifetime subscriber

  #2525933 20-Jul-2020 10:26
Send private message

Sparky787:

 

Hi - thank you for your quick reply.

 

The Format feature does not work with Time/Date because it does not have the right formats.

 

There is a custom format that will allow HH:MM, but when I convert the existing data, I don't get the desired result. I need the data to be a cumulative count of hours and minutes. 

 

When I try the custom format, it does not work either. 77:91 (which should be 77 hours and 51 minutes) converts to 21.## 
I've not quite figured out the logic behind it yet.

 

 

You need to convert the numbers to fractions of "24 hours", and then apply a format:

 

As an example, in a blank Excel spreadsheet, I've just done this in one cell:

 

=135.99/24

 

as a formula, which makes the value of the cell "5.66625", then set the cell-fomat to "[h]:mm" (right-click cell, format cells, select "custom", then in the "Type" field, enter "[h]:mm"

 

Result displays as:

 

135:59

 

 


Create new topic








Geekzone Live »

Try automatic live updates from Geekzone directly in your browser, without refreshing the page, with Geekzone Live now.



Are you subscribed to our RSS feed? You can download the latest headlines and summaries from our stories directly to your computer or smartphone by using a feed reader.