MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Date/Time format problem


Posted by Richard Rusk on July 29, 2001 4:18 PM

I am trying to use a summed subtotal hours value (in the [hh]:mm format) in a formula multiplying it with my $/hr value (in the currency format). eg. 47:40*$25.00 but end up with $49.65 (clearly wrong). It is actually because the true value is 1.986111111*$25.00. So how do I convert the value into seperate hour and minute values in a decimal format? Thus far the hour() and minute() formulae don't seem to work, so where to now...
Anyone out there...
Thanx
R2


Posted by Aladin Akyurek on July 29, 2001 5:35 PM

Try:

=time-value*24*$25.00

Aladin

Posted by Ian on July 29, 2001 7:10 PM

Very Short!