Time to general format

  • Thread starter Thread starter news.microsoft.com
  • Start date Start date
N

news.microsoft.com

I have a time sheet that calculates hours worked(end time - start time) ,
and then totals hours for the week. The problem is I need this total for
the week to be a real number so that I can figure weekly salary by
multiplying by hourly rate. Can you help. My time format is h:mm AM/PM

Thanks Mike
 
Hi Mike
for calculating the sum just add the daily hoers and format the total
cell with the custom format [hh]:mm.
To calculat the weekly salary multiply this value with 24 and your
hourly rate:
=A9*24*B9
where A9 stores your total hours per week and B9 your hourly rate
HTH
Frank
 
Hi

Excel stores time in 24 hour format.
Multiply the value you have by 24 then by your hourly rate to get the total
value.

Your cell totalling the number of hours will need to have a Custom format of
[h]:mm to prevent it from going back to 0 when the value exceeds 24
 
Back
Top