Time Format Excel: Change hh:mm:ss to just hours or minutes

Dear All,

This is my first post so apologies if anything is missing. I work in the hospitality industry and we have new systems implemented that give a lot of data that we would like to start using.

I have a question about the time format that Excel seems to be applying to a time period.

The system is exporting the data in CSV as hh:mm:ss (hours:minutes:seconds) for example 122:44:56. Excel is not reading it the same way and is converting it to amount of days and then hours (less than 24 hours), minutes and seconds. So this is what excell displays in the cell: 05/01/1900 02:44:56. The 05/01/1900 means it is 5 days, and then 2 hours 44 minutes and 56 seconds.

Is it possible for Excel to just show this in amount of hours or even amount of minutes? I have tried several formatting options but not getting the data as we need it.

Attached is the sheet and all we want to do is calculate the amount of calls per hour or revenue per hour for example.

Thank you for your help,

Ton

B18 = 122:44:56

format/ general: 5.11453
or
format/custom/ Type: [hh] = 122
or
format/custom/ Type: [mm] = 7364

Do they meet output expection?

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. As you are new here, I have done it for you this time.)