•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Does it exist a time format that doesn't require to always write the two points?
I'll be more precise.
I'm creating a new sheet for the shifts schedule at work and I'm trying to figure out a way where when I insert a number in the cell, it gives me the hour and the minutes only (ex.: 14 becomes 14:00 and 14:30 also becomes 14:30). The cell format is hh:mm but when I insert just a number without the two points, or the minutes, it automatically convert the number into a date, even if it's set as an hour. Is there a way to do this or am I doomed to write every time the exact time?
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#real-time data collaboration
#real-time collaboration
#Excel alternatives for data analysis
#rows.com
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#Excel alternatives
#hh:mm
#time format
#hour
#minutes
#shifts schedule
#cell format
#Excel
#insert number
#automatic conversion
#formatting issue
#work schedule
#date