So, I'm developing a timesheets functionality for our product.
For the week view I have a grid and a model bound to it with some ids for project/client/item/etc. and each of the seven days of the week as decimals.
This works great when entering the time as decimal values, eg: 2.5 or 1.15. I use a clientTemplate to format it and display it as 02:30 or 1:09.
So far so good. Now comes the requirement that we want to be able to also input time as 2:30 or 1:09. The problem is the input box does not allow me to input the ":" sign. My workaround was to use string instead of decimal in the model for days. Got that to work nicely but now the sum aggreggates don't work anymore.
Since I know we cannot have custom aggreggates my question is: how can I sort this issue? I would prefer to have the model as decimal and a way to also input time as 00:00 since I can split them apart and make a decimal out of it to fit the model.
Thank you for your time.