View Single Post
  #1   Report Post  
Niek Otten
 
Posts: n/a
Default

=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