Using the result of date math in regular calculations

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tony Olson - 15 Oct 2004 15:47 GMT

I doing date math on a Hourly Pay worksheet (for a class).
5:30 - 1:30 = 4:00 - I want to take the result of the subtraction (4:00) and
multiply it times a Hourly Rate cell except the format of the number of
hours is in a custom/date format. What's the easiest way to convert this to
a number?

Thanks.

Tony Olson

Reply to this Message

Frank Kabel - 15 Oct 2004 16:20 GMT

Hi
use
=(A2-A1)*24*hourly_rate

Signature

--
Regards
Frank Kabel
Frankfurt, Germany

> I doing date math on a Hourly Pay worksheet (for a class).
> 5:30 - 1:30 = 4:00 - I want to take the result of the subtraction (4:00) and
[quoted text clipped - 5 lines]
>
> Tony Olson

Reply to this Message