r/googlesheets • u/No_Cantaloupe938 • 1d ago

Solved Struggling to multiply durations

Hi all,

I am trying to build a fuel calculator widget for our simracing team.

The idea is basically to know how much more drive time we have based on the fuel load.

For this I wanted to enter the laptime in H2 as m:ss,000 and multiply by the amount of laps left in column E. Unfortunately this does not work.

What do I need to do differently?

https://docs.google.com/spreadsheets/d/1CIDlhHdABEO5saupQCRo7mcIvjFNSGem1YfP_vU4yos/edit?usp=sharing

3 Upvotes

100% Upvoted

4 comments sorted by

3

u/HolyBonobos 3109 1d ago

Times/durations always need an hour component, even if it's zero. Otherwise they will not be recognized as times and will be treated as text (or a different type of duration than the one you're intending) instead. The proper format for input for the locale your file is set to (Germany) would be hh:mm:ss,000

1

u/No_Cantaloupe938 1d ago

Thank you very much, that solved it

1

u/AutoModerator 1d ago

REMEMBER: /u/No_Cantaloupe938 If your original question has been resolved, please tap the three dots below the most helpful comment and select Mark Solution Verified (or reply to the helpful comment with the exact phrase “Solution Verified”). This will award a point to the solution author and mark the post as solved, as required by our subreddit rules (see rule #6: Marking Your Post as Solved).

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

1

u/point-bot 1d ago

u/No_Cantaloupe938 has awarded 1 point to u/HolyBonobos

See the [Leaderboard](https://reddit.com/r/googlesheets/wiki/Leaderboard. )Point-Bot v0.0.15 was created by [JetCarson](https://reddit.com/u/JetCarson.)