Cell Formatting

you should use the function dur2hours() to convert from a duration to a number. Then the multiplication will work as expected. You can get more details by opening the function browser using the menu item "View > Show Function Browser"

Hi dj,

You wrote: "BUT it returns the value as time and I'd like it to display in dollars $$$."

Actually, the formula returns a Duration value (as it should), not a Time value.

Suppose you spent three hours in the dentist's chair (3:00)

Then the dentist told you she'd need two more sessions (same duration) to complete the work.

The formula to calculate the total duration of your visits is 3 x 3:00, and the result is 9:00 (nine hours and zero minutes. The perceived duration is, of course, much greater.

Clicking the currency symbol in the format bar will set the cell to display a numeric value as currency. Since the value in the cell is a duration value, which can't be formatted as currency, the chosen format will be overruled, and a duration format applied.

As Wayne suggested, you need to use DUR2HOURS() to convert the duration amount to a number representing the number of hours (and fraction of hours) equivalent to the duration value shown.

There are two places in your example where this can be applied, depending whether you want to keep the duration display in C1.

If you'd be happy seeing a number in that then use =(DUR2HOURS(B1-A1) in cell C1, and =C1*15 in D1

If you'd like to keep the duration value displayed in C1, use =B1-A1 in cell C1, and =(DUR2HOURS(C1)*15 in D1.

Regards,

Barry

Regards,

Barry

Amazing! Thanks Barry. This was the exact problem I was having, and the exact solution.