ExcelBanter - change time into money

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - change time into money (https://www.excelbanter.com/excel-discussion-misc-queries/157400-change-time-into-money.html)

tallos3

change time into money

I have 35 hours and 30 minutes overtime in my work (35:30). I need to
calculate how much many I will take. Let's say the time is 5 euros. That's
35:30*5=177,5 euros. What's the format in XL?

Thank u
tallos

Mike H

change time into money

Hi

A1 = 35:30
B1 = 5
c1 = A1 * B1 * 24

Mike

"tallos3" wrote:

I have 35 hours and 30 minutes overtime in my work (35:30). I need to
calculate how much many I will take. Let's say the time is 5 euros. That's
35:30*5=177,5 euros. What's the format in XL?

Thank u
tallos

All times are GMT +1. The time now is 07:09 PM.