Devam Ediyor

520890 Simple Excel Programming

I have a very simple problem but I'd like a professional to help me with it.

I am using an Excel spreadsheet to keep track of a large number of audio files of various lengths. I want to input the number of minutes and seconds in a column. For example, if a file is one hour, 47 minutes, 33 seconds long, I would type into the spreadsheet:

107:33

I would also like the option (perhaps in another column?) of formatting as follows. I type 107:33 and the result comes up:

[url removed, login to view]

That is, I would like to see the result as the length in minutes with a decimal: 107 33/60 minutes = [url removed, login to view] minutes.

Microsoft Excel's time formats aren't very good for working with duration (as opposed to time of day). I run into all sorts of issues when I try to use them. I simply want to input my data without Excel doing all sorts of funky things to it. When I type 274:33 I want that to actually mean 274 minutes and 33 seconds.

Please express understanding of this issue when you apply. At the moment, the Length column is formatted as text. The current file is attached.

Please estimate time needed to resolve this issue. More work may be available in the future if I like your work.

Beceriler: Her şey Kabul, Excel, PHP

Daha fazlasını görün: understanding programming, programming number, programming help needed, number programming, microsoft excel spreadsheet, microsoft excel professional, microsoft excel number formats, microsoft excel help, formats excel, excel help needed, excel data programming, d programming, audio express, microsoft programming, future programming, microsoft excel programming, spreadsheet microsoft excel, simple excel, resolve simple php issue, excel formatting, audio problem, hour programming, excel text column, simply data excel, formatting data microsoft excel

İşveren Hakkında:
( 0 değerlendirme )

Proje NO: #2266827