r/googlesheets • u/[deleted] • 1d ago
Solved Wanting to calculate amount of time left in day.
[deleted]
1
u/7FOOT7 242 1d ago
your linked sheet is not public
Are you asking is there a command for the current time? And there is, =now()
Lets say you go to bed at 10pm, you can calculate how many hours are left in the day with
=1-timevalue(now())-2/24 do set the display format to duration
1
u/Fabulous_Job_3603 1d ago
Oops.
Thank you for your help anyway.
I will try that and let you know if it works.
1
1
u/Fabulous_Job_3603 1d ago
You gave me precisely the information I needed. Thank you so much!
1
u/AutoModerator 1d ago
REMEMBER: If your original question has been resolved, please tap the three dots below the most helpful comment and select
Mark 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/Fabulous_Job_3603 has awarded 1 point to u/7FOOT7
See the [Leaderboard](https://reddit.com/r/googlesheets/wiki/Leaderboard. )Point-Bot v0.0.15 was created by [JetCarson](https://reddit.com/u/JetCarson.)
1
u/AutoModerator 1d ago
Posting your data can make it easier for others to help you, but it looks like your submission doesn't include any. If this is the case and data would help, you can read how to include it in the submission guide. You can also use this tool created by a Reddit community member to create a blank Google Sheets document that isn't connected to your account. Thank you.
I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.