Hi all
I have a start date/time and an end date/time. If there is no end time then I use today's date at the top(for this purpose I have written in a static date).
I check if no start date use "-"
If no end date use the today field
Now the issue is it works unless you have the last date in the month, it has not counted it so I check if it is the last day all the way up to 23:59:59and add 1440 minutes. Great worked, but then it adds he previous month's minutes to the month after.
I have spent to long looking at this, I hope you can see what I am trying to do.
Basically start time to end time, and split into the months in which they occur, works except for if you use the last day. Need to use minutes
Please help, sorry for the bad explanation!
Bookmarks