Great Work!
Below I've listed some suggestions that could perhaps make your life easier.
tl;dr; Go to ( https://docs.google.com/spreadsheets/d/1imXKEyXMDCbZfy7ZpT_N_bEcjLZB_Ta2gXL9yoGUSS8/edit?usp=sharing ) to view a sheet that implements all of the suggested changes. It's read only but you can copy and paste from it.
Suggestions:
1. When creating a new row copy and paste from the last row in order to preserve formulas and formating.
2. Create a cell that automatically tracks the current count. You can do this with the following formula assuming the first Kojima Number is in cell A7:
=MAX(A7:A)
3. Set the Kojima number to autoincrement. Start by manually entering the number 1 into A7 then in A8 use the following formula:
=A7+1
4. Store time values as durations. Time values have a bunch of quirks and are best left to Google Sheets to manage. Not only does Google Sheets take care of the hard stuff it also allows you the user to easily compute things like averages and sums for durations using formulas. If need be, you can show duration values in terms of seconds (see suggestion 5). To use durations select cell C7 then select the menu option Format > Number > Duration. To enter time values use type them in the following way: hours:minutes:seconds. For example, 0:04:55 .
5. To display durations as seconds use a formula coupled with a custom date format. In cell D7 enter the following formula:
=C7
Then create a custom format by selecting cell D7 then selecting the menu Format > Number > More Formats > More Data And Time Formats. A dialog titled Custom date and time formats should appear. Delete all of the items in the dialog's textbox by clicking each one and then selecting delete from the menu that appears. After all of the items have been removed click the drop-down icon on the right of the textbox. A menu should appear. From this menu under the duration column select Elapsed seconds. Finally click the Apply button.
6. Spreadsheets work best when only one peace if information is stored per cell. I suggest you break out the description (e.g. Fox Logo) of the Kojima mention into it's own column separate from the type (e.g. OC).
---
(7.) This is not really a suggestion and it not advisable that you do it but if you insist on storing time values in seconds you can convert them to durations using the following hack:
=TIMEVALUE(CONCATENATE("0:0:",C7)) then format the cell as duration.
Log in to comment