# 💯 Number formats **URL:** \ **Category:** General\ **Created:** [March 6, 2020, 12:20am UTC](https://community.glideapps.com/t/number-formats/5226 "2020-03-06T00:20:20Z")\ **Posts on this page:** 1\ **Showing post:** 7
**Author:** ![Hemmings](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hemmings/32/3799_2.png) [@Hemmings](https://community.glideapps.com/u/Hemmings)\ **Post date:** [March 7, 2020, 11:57am UTC](https://community.glideapps.com/t/number-formats/5226/7 "2020-03-07T11:57:09Z")
just in time too! I began searching for a solution to this problem yesterday! I do have another number format problem with dates though. A few columns in my app work out the difference between two date/times and spits out the result as a number (i.e, 11:50 is formatted as 43897.4930555556) in my sheet. The value is input from my app into the the sheet using a form component (which requires a date//time selector, when i ONLY need a time selector … [more on that here](https://community.glideapps.com/t/time-picker/774/7)). The sheet also has an array formula to perform the difference calc, which is also formatted in as a number. any suggestions on how to have the results in my sheet automatically formatted to a time format? --- _[View the full topic](https://community.glideapps.com/t/number-formats/5226)._