Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
185
Views
Topic starter
Hello!
I'm trying to create a histogram in Excel where the bin width is 5 minutes, but every time I go to Format Axis > Bin width and paste in the decimal value for five minutes (0.00347222222222222), Excel deletes the recurring 2s, leaving me with slightly less than 5 minutes (0.00347). How do I get it to accept values to more decimal places?
Many thanks,
Saul
Posted : 22/07/2021 9:53 am
You can try to change from time format to decimal system, multiplying the current values with *24*60, instead of 0.003472 you will have 5.00 for example.
Posted : 24/07/2021 2:56 pm
