how to change the h:mm format to number?

B

Bel

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
 
A

Aladin Akyurek

Supposing that A1 houses a true time value like 8:25 (formatted as
[h]:mm)...

=A1*24*HourlyRate
 
N

Niek Otten

=A1*24, format as number, not time.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 

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

Similar Threads

Formatting question: how to format duration (time spent)? 0
Please help: 'Change working time' does NOT change working time 1
How do I calc the time difference in hh:mm for shift work? 12
Round it off 3
Time Sum in Excel 1
Time Calculation 9
Calculating Resolution Rates 3
TimeSheet Using 100 Minutes & Rounding to .25 2

Top