Working With Time

[srbarlow]

I use time a lot for calculations and had to figure a way to manage time input and manipulation.

I have time entered in the two decimal format H.mm where H is hours and mm is minutes from 0 to 59. Note that for minutes less than 10 the leading zero must be entered.

To convert an input in this form to minutes for use in calculations I use the following trick:

(( Hmm - ( mod (( Hmm*100), 100) / 100)) *60) + ( mod(( Hmm*100), 100))

after performing calculations with minutes ( elapsed time for example), the following will convert whole minutes back into the decimal H.mm format.

((( MINS -(mod(MINS,60)))/60) + ((mod(MINS,60))/100))

At least this is how I did it with the limited library of functions in Go Calc.

I'd like to see some string functions and also some input error checking.

I like to be able to set an input format and value range and create a custom error string to alert a user if the improper format or values range was entered.