# How can I achieve conditional formatting for HH:MI?

**URL:** <https://community.amazonquick.com/t/how-can-i-achieve-conditional-formatting-for-hh-mi/14182>\
**Category:** Q&A\
**Tags:** analysis, calculations, quick-sight\
**Created:** [June 2, 2023, 7:46am UTC](https://community.amazonquick.com/t/how-can-i-achieve-conditional-formatting-for-hh-mi/14182 "2023-06-02T07:46:51Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Biswajit\_1993](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/biswajit_1993/32/20472_2.png) [@Biswajit\_1993](https://community.amazonquick.com/u/Biswajit_1993)\
**Post date:** [June 2, 2023, 7:46am UTC](https://community.amazonquick.com/t/how-can-i-achieve-conditional-formatting-for-hh-mi/14182/1 "2023-06-02T07:46:51Z")

</div>

Hi Team,  
Need you help for finding my solutions.  
PFB the calculation  
 ![image](https://d1wl4jav5dp96l.cloudfront.net/original/2X/3/339690e635e8dbca739bd4d92cae49dbe7127b1d.png)

Here what happened everything is fine when the HOUR is Integer Number type that is only _ **HOUR** _ type but when it is _ **HOUR With Min** _ then the result showing Wrong.

Lets Say , _ **If Start Date Min - Calc - 6:30** _ then it should be under as _ **Amber** _ but it is showing **_Green_.**

So any idea how can I achieve this.

Thanks & Regards  
Biswajit Dash

---

<div class="post-metadata">

**Author:** ![Sanjeeb2022](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/sanjeeb2022/32/20947_2.png) [@Sanjeeb2022](https://community.amazonquick.com/u/Sanjeeb2022)\
**Post date:** [June 2, 2023, 8:25am UTC](https://community.amazonquick.com/t/how-can-i-achieve-conditional-formatting-for-hh-mi/14182/2 "2023-06-02T08:25:37Z")

</div>

Hi @Biswajit_1993 - Can you put the condition for minutes along with hour then both the fields will be integer.

Regards - Sanjeeb

---

<div class="post-metadata">

**Author:** ![DeepakS](https://avatars.discourse-cdn.com/v4/letter/d/b2d939/32.png) [@DeepakS](https://community.amazonquick.com/u/DeepakS)\
**Post date:** [June 5, 2023, 8:45pm UTC](https://community.amazonquick.com/t/how-can-i-achieve-conditional-formatting-for-hh-mi/14182/3 "2023-06-05T20:45:11Z")

</div>

@Biswajit_1993, did @Sanjeeb2022 response answer your question? If so, please help the community out by marking this answer as “Solution!”

---

<div class="post-metadata">

**Author:** ![Biswajit\_1993](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/biswajit_1993/32/20472_2.png) [@Biswajit\_1993](https://community.amazonquick.com/u/Biswajit_1993)\
**Post date:** [June 6, 2023, 11:06am UTC](https://community.amazonquick.com/t/how-can-i-achieve-conditional-formatting-for-hh-mi/14182/4 "2023-06-06T11:06:17Z")

</div>

Hi @Deepak I am trying out with @Sanjeeb2022 solutions but not able to get the desired result.

Thanks & Regards  
Biswajit Dash

---

<div class="post-metadata">

**Author:** ![Sanjeeb2022](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/sanjeeb2022/32/20947_2.png) [@Sanjeeb2022](https://community.amazonquick.com/u/Sanjeeb2022)\
**Post date:** [June 6, 2023, 11:09am UTC](https://community.amazonquick.com/t/how-can-i-achieve-conditional-formatting-for-hh-mi/14182/5 "2023-06-06T11:09:42Z")

</div>

Hi @Biswajit_1993 - What is the issue you are observing?

Regards - Sanjeeb

---

<div class="post-metadata">

**Author:** ![Biswajit\_1993](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/biswajit_1993/32/20472_2.png) [@Biswajit\_1993](https://community.amazonquick.com/u/Biswajit_1993)\
**Post date:** [June 7, 2023, 9:12am UTC](https://community.amazonquick.com/t/how-can-i-achieve-conditional-formatting-for-hh-mi/14182/6 "2023-06-07T09:12:39Z")

</div>

Hi @Sanjeeb2022 Thanks for your suggestion now its working fine.

Thanks & Regards  
Biswajit Das