Using the result of date math in regular calculations

T

Tony Olson

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top