Hi All,

I have data validation boxes containing numbers. 1 column is for # of hours the other column contains # quarterly minute options.

I need to find out how, when selected, the hours and minutes will calculate as hours and minutes rather than on a quarter system

i.e. column 1 column2 total or it add everything up but does not provide me with the total # of hour/minutes


1 :15 1.25

any help would be appreciated

Thanks!~