Google-sheets – How to convert a rational number like 1.6 to the higher integer number

The function VLOOKUP is only usable within a spreadsheet. This means that you use sheets !! Therefore I created a sample, based on sheets.

If you want to use spreadsheets however, then study the IMPORT function or Google Apps Script.

Remarks to the example:

1. I've created a table like the wiki page you included, with the calculated total. You can hide this sheet and lock it for updates, for anyone but you.
2. Pay attention to sheet 2, cell A11.
3. I've hidden rows 1 to 10 to make the autocomplete function to work.
4. See B1 in sheet 2, how it's done.

File I prepared with working example

Adding a sample of you own, helps a great deal to better understand what you mean !!

UPDATE: I've added edit rights to the example file I created, so you can play with it. Changed the names as well, each now being different (makes the auto-complete function work)

If your 0:01:00 is a date/time index (numeric rather than a string) the underlying number is an integer for days and a decimal for time. as there are 24*60*60 seconds in a day the number of seconds represented by 0:01:00 is effectively the number of seconds between midnight and one minute past midnight, which for A1 can be calculated as:

=86400*A1