kilometers

  1. F

    using Hyperlink function to extract Google kilometers into Excel Spreadsheet automatically

    Dear members of the forum, I'm struggling with a mind-numbing task that needs immediate automation. While we're looking for cheap alternatives to employ for automating kilometer calculation from point A to point B, I thought it's best to inquire the forum what are the possible options to 1)...
  2. T

    Gathering information by year

    I have a excel vehicle tracking system that uses log sheets entered by trip that has a date associated with each entry. This includes kilometers driven for that date and for what vehicle. I have the ability to change the year and month on a report tab that will produce the kilometers per vehicle...
  3. D

    Lookup text in one column, return date from same row in different column

    Using Excel 2016. In the GMH Table, I am attempting to Lookup "Gas Tank Fill" in Event column of the History Table to return the date from same row in the Out column of the History Table using a table that will advance the formula when the next row is added. =LOOKUP("Gas Tank...
  4. L

    Calculating Speed

    Hello. I am looking for a formula to calculate how far you travel in ONE SECOND at both 40 KPH and 60 KPH. Yes Kilometers Per Hour. I am in Canada!!
  5. N

    Converting kilometers to time in quarter hour decimals

    Hello everyone, I am trying to program a timesheet to take a staff members kilometres driven and convert it to a decimal using a 1minute = 1kilometre ratio. However where I work, we must express time in quarter hour decimals. 0.25=15 minutes, 0.5=30 minutes and so on. Right now I am simply...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top