Can anyone tell me how to make a field with a formula in it turn the
product of the calculation into time format (HH:MM)? For example, say
you have two fields; Field 1, into which you input data, and Field 2
which gets the data from the Field 1 and changes it to time format. You
put the value of 0.75 into Field 1, and Field 2 is supposed to change it
to 1:15 (1hr, 15mins).I've tried making Field 2 a time field, but I
can't get it to work. I've also tried to use that timefmt function, but
either ...