=(end time - start time) * rate per hour * 24 HTH. Best wishes Harald
B Ben McBen Dec 10, 2004 #2 Time dates are represented at the "rate" of 1 = 1 day. So 1/24 id the equivalent of 1 hour, so time2-time1 /(1/24) gives you the number of hours (and pro-rata for any minutes/seconds. You may want to use the round function to modify this.
Time dates are represented at the "rate" of 1 = 1 day. So 1/24 id the equivalent of 1 hour, so time2-time1 /(1/24) gives you the number of hours (and pro-rata for any minutes/seconds. You may want to use the round function to modify this.
