I am writing a small timesheet application for personal use.
What this does is helps me keep track of exactly how many minutes I have worked, so I can bill accordingly.
Once I've actually got it working, I plan to have it write a custom PDF for me. Easy stuff.
Have a look at the following screencaps:
Here is how it works:
I enter a 24-hour time value (without colon) into the textbox.
After pressing "+", the time is added to the list box. A variable called SuffixPending is set to 1, so the system knows that the next time a value is entered, it is to be appended to the same line - to make a complete timeframe row.
It then changes the variable back to 0, so that the next line can be added.
This all works sweet.
BUT, I am completely stumped on how to get C2 to treat the values as base60 (I think that's the term I'm looking for - I am absolutely terrible at maths). What I'm trying to say is for example, for the first screenshot there, I want it to return "60" instead of "300" in the TotalMinuteCount variable - and therefore also in the text label down the bottom.
Preferably, if possible, I would like to make it so that it returns total hours to two decimal places (eg, for 0230 - 0400, it should show "1.5" - instead of minutes. ButI'll work with whatever answers people can come up with.
Please explain in simple terms. As I stated before, I am really bad at maths.
I've already had a look through Scirra's manual about the Timer control. Their guide is useless as it only shows how to convert seconds to different minutes/hours.
For those confused by the event sheet, the extra variables and actions there such as "ListItemCountUpTo" exist to count the rows correctly. That part is working fine.