A akm11793 New Member Jul 10, 2024 #1 Here's what I need - I15 x 0.0885 up to 40 hours only and converted to 2 decimal points so I have =MIN(I15*0.0885, 40*0.0885)*24 but currently in I15 I have 40:30:00 and it's calculating that 30 minutes but I only want it calculated to 40 hours. Help please!
Here's what I need - I15 x 0.0885 up to 40 hours only and converted to 2 decimal points so I have =MIN(I15*0.0885, 40*0.0885)*24 but currently in I15 I have 40:30:00 and it's calculating that 30 minutes but I only want it calculated to 40 hours. Help please!
A akm11793 New Member Jul 11, 2024 #3 p45cal said: A guess: =MIN(TIMEVALUE("40:00:00"),I15)*0.0885*24 Click to expand... Thank you but it didn't work! My number is off even more
p45cal said: A guess: =MIN(TIMEVALUE("40:00:00"),I15)*0.0885*24 Click to expand... Thank you but it didn't work! My number is off even more
A akm11793 New Member Jul 11, 2024 #4 p45cal said: A guess: =MIN(TIMEVALUE("40:00:00"),I15)*0.0885*24 Click to expand... Okay I went another way and got it - I used =MIN(I15, "40:00:00") * 0.0885 *24 and it worked.
p45cal said: A guess: =MIN(TIMEVALUE("40:00:00"),I15)*0.0885*24 Click to expand... Okay I went another way and got it - I used =MIN(I15, "40:00:00") * 0.0885 *24 and it worked.