[Solved] Time In Hours And Minutes...

[JoelDennysDM]

Hello Team,

I need some help with time and minutes.

Please see the spreadsheet as I have place the note right in it.

Your help is greatly appreciated.

[FJCC]

How is this?

[JoelDennysDM]

Hello FJCC,

I will like to thank you for your help.

I have added some modifications on my sheet.

Can you please take a look and see if you can help me out further.

I did write Modification in the Yellow Post It Notes inside the sheet.

Thanks again for your help.

[FJCC]

I think this captures all of your modifications.

[JoelDennysDM]

Hello FJCC,

Again, you are truly a life saver.

I need a few more final touches and we should be coming to an end on this project.

Can you please look at the modifications on the attach file.

I noted all modifications on the post it notes.

Thanks...

[FJCC]

The requirement for cell Z2 is far too complicated. I think all you need to test is whether U2 = C.T.F. If that is true, add 10 minutes to P2, otherwise just use P2.

Code: Select all

=IF(ISBLANK(U2);"";IF(U2 = "C.T.F.";P2+10/24/60;P2))

For the formula for BI2, you have to remember that the value in AY2 is in units of Days. It is displayed as 08:00 but the value is 8/24 Days or 0.33333. To calculate the pay, you have to multiply AY2 by 24 and then multiply by the hourly rate.

Similarly for the formula in BN2, the value in BD2 has to be converted from its value in Days to the value in minutes. Multiply BD2 by 24*60 and then by the rate in BP1.

[RusselB]

You could replace the 10/24/60 in FJCC's code with time(0;10;0)
Technically it's the same amount of time, and it does make the code a little longer, but might be easier if you want to use other times or change it for a time that isn't exact minutes.
Just a suggestion