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


#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. 

 

 


Filter this topic showing only the reply marked as answer Create new topic

Stu

Stu
Hammered
8332 posts

Uber Geek

Moderator
ID Verified
Trusted
Lifetime subscriber

  #2525909 20-Jul-2020 09:38
Send private message

You'll need to edit the required cells (select cells, right click, edit cells) and change to time/date and pick your required format.

Off the top of my head. Not near a computer.




People often mistake me for an adult because of my age.

 

 

Keep calm, and carry on posting.

 

 

Referral Links: Sharesies - Backblaze

 

Are you happy with what you get from Geekzone? If so, please consider supporting us by subscribing.

 

No matter where you go, there you are.




Linux
11391 posts

Uber Geek

Trusted
Lifetime subscriber

  #2525920 20-Jul-2020 10:03
Send private message

Stu: You'll need to edit the required cells (select cells, right click, edit cells) and change to time/date and pick your required format.

Off the top of my head. Not near a computer.

 

Correct and it's very simple


Sparky787

69 posts

Master Geek


  #2525924 20-Jul-2020 10:05
Send private message

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.

 

 




jamesrt
1609 posts

Uber Geek

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

 

 


Sparky787

69 posts

Master Geek


  #2525940 20-Jul-2020 10:41
Send private message

Thank you very much - this worked a treat.


Filter this topic showing only the reply marked as answer Create new topic





News and reviews »

Air New Zealand Starts AI adoption with OpenAI
Posted 24-Jul-2025 16:00


eero Pro 7 Review
Posted 23-Jul-2025 12:07


BeeStation Plus Review
Posted 21-Jul-2025 14:21


eero Unveils New Wi-Fi 7 Products in New Zealand
Posted 21-Jul-2025 00:01


WiZ Introduces HDMI Sync Box and other Light Devices
Posted 20-Jul-2025 17:32


RedShield Enhances DDoS and Bot Attack Protection
Posted 20-Jul-2025 17:26


Seagate Ships 30TB Drives
Posted 17-Jul-2025 11:24


Oclean AirPump A10 Water Flosser Review
Posted 13-Jul-2025 11:05


Samsung Galaxy Z Fold7: Raising the Bar for Smartphones
Posted 10-Jul-2025 02:01


Samsung Galaxy Z Flip7 Brings New Edge-To-Edge FlexWindow
Posted 10-Jul-2025 02:01


Epson Launches New AM-C550Z WorkForce Enterprise printer
Posted 9-Jul-2025 18:22


Samsung Releases Smart Monitor M9
Posted 9-Jul-2025 17:46


Nearly Half of Older Kiwis Still Write their Passwords on Paper
Posted 9-Jul-2025 08:42


D-Link 4G+ Cat6 Wi-Fi 6 DWR-933M Mobile Hotspot Review
Posted 1-Jul-2025 11:34


Oppo A5 Series Launches With New Levels of Durability
Posted 30-Jun-2025 10:15









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.