# Create time-based availability status in Thunkable using Google Sheets

**URL:** <https://community.thunkable.com/t/create-time-based-availability-status-in-thunkable-using-google-sheets/3436554>\
**Category:** Questions about Thunkable X\
**Tags:** beginner, help\
**Created:** [December 27, 2024, 9:45am UTC](https://community.thunkable.com/t/create-time-based-availability-status-in-thunkable-using-google-sheets/3436554 "2024-12-27T09:45:12Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![matt\_conroy](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/matt_conroy/32/150843_2.png) [@matt\_conroy](https://community.thunkable.com/u/matt_conroy)\
**Post date:** [December 27, 2024, 4:04pm UTC](https://community.thunkable.com/t/create-time-based-availability-status-in-thunkable-using-google-sheets/3436554/2 "2024-12-27T16:04:25Z")

</div>

Hi kongchichen00793frzt, welcome to Thunkable! 🎉

Be sure to check out [How to ask Great Questions v2.0](https://community.thunkable.com/t/how-to-ask-great-questions-v2-0/2689983/1), the [Community Guidelines](https://community.thunkable.com/t/community-guidelines/78/8), and our [Getting Started Guide](https://docs.thunkable.com/getting-started/get-started) to make the best of your Thunkable Community experience!

This can be a bit tricky as you’re dealing with time but you’ve got the psuedo code pretty correct. You’ll want to use the [comparison blocks](https://docs.thunkable.com/blocks/blocks/logic#comparison-blocks) and an [if/else statement](https://docs.thunkable.com/blocks/blocks/control#if-do-and-if-do-else) to check if the current time falls within the range of times. If the current time value is greater than the start time but less than the end time, you’ll set a label to Available, else you can set it to Unavailable.

---

_[View the full topic](https://community.thunkable.com/t/create-time-based-availability-status-in-thunkable-using-google-sheets/3436554)._