HRA Exemption Calculation

Hi,

I am here to help you calculate HRA Exemption of your Salary Component under u/s 10(13A). Please download the attachment and find it helpful.

Download Excel

Thanks for reading my blog !

Read More

Microsoft Excel: Convert Seconds to HH:MM:SS Format

1. Open Microsoft Excel

2. Select cell B1, name it as seconds and in the cell B2 type the value to be converted to HH:MM:SS format.

3. Then select cell C1, name the cell as HH:MM:SS and paste the below formula in the cell C2.

=CONCATENATE(TEXT(TRUNC(B2/3600),"00"),":",TEXT(TRUNC(MOD(B2,3600)/60),"00"),":",TEXT(MOD(MOD(B2,3600),60),"00"))

4. And here is seconds converted to HH:MM:SS format. 

Thank you for reading my blog. !

Read More