I need calculated time in a "real number" format
 

Hello everyone...this is my first time using the forum. Hopefully you can
help. I am calculating the difference between two times in a spreadsheet to
arrive at the number of hours an employee works during the day. I then want
to multiply that times their hourly rate to arrive at the payroll cost. Of
course, this does not work because Excel sees the calculated difference as a
decimal instead of the number of hours.

Can anyone tell me how I can turn the calculated time difference into a
number I can use to calculate the payroll cost....

Example 10 am - 2 p.m. = 4 hours for day 4 * $15 = $60 payroll cost.

Thank you!

I need calculated time in a "real number" format
 

Hi,

Subtract the times and multiply by 24 to get decimal hours so

=(B1-A1)*24*15

Wii return 60

Mike

"MRH" wrote:

Hello everyone...this is my first time using the forum. Hopefully you can
help. I am calculating the difference between two times in a spreadsheet to
arrive at the number of hours an employee works during the day. I then want
to multiply that times their hourly rate to arrive at the payroll cost. Of
course, this does not work because Excel sees the calculated difference as a
decimal instead of the number of hours.

Can anyone tell me how I can turn the calculated time difference into a
number I can use to calculate the payroll cost....

Example 10 am - 2 p.m. = 4 hours for day 4 * $15 = $60 payroll cost.

Thank you!

I need calculated time in a "real number" format
 

I forgot, format as General

"Mike H" wrote:

Hi,

Subtract the times and multiply by 24 to get decimal hours so

=(B1-A1)*24*15

Wii return 60

Mike

"MRH" wrote:

Hello everyone...this is my first time using the forum. Hopefully you can
help. I am calculating the difference between two times in a spreadsheet to
arrive at the number of hours an employee works during the day. I then want
to multiply that times their hourly rate to arrive at the payroll cost. Of
course, this does not work because Excel sees the calculated difference as a
decimal instead of the number of hours.

Can anyone tell me how I can turn the calculated time difference into a
number I can use to calculate the payroll cost....

Example 10 am - 2 p.m. = 4 hours for day 4 * $15 = $60 payroll cost.

Thank you!