=A1*24, format as number, not time.
--
Kind Regards,
Niek Otten
Microsoft MVP - Excel
"Bel" wrote in message
...
When calculating hourly pay, I need to change the format of h:mm to
number,
then time hourly rate. For example: 8 hrs & 25 mins. I need to turn 25min
into 0.42hrs.
8.42 hrs*10= $84.20
|