I need a formula please to calculate total payment per hour and minutes as follows:
1 working hour worth 150, with minimum payment of 450.
I have total working hours and minutes [h]:mm] in cell A1.
I need a formula please to calculate total payment per hour and minutes as follows:
1 working hour worth 150, with minimum payment of 450.
I have total working hours and minutes [h]:mm] in cell A1.
Put this in B1:
=MAX(450,150*A1*24)
Hope this helps.
Pete
Yes it did, however is there a way please to modify the given formula to reflect zero if the time value in cell A1 is negative value?
Add that to Pete's solution..
=IF(a1<0,0,MAX(450,150*A1*24))
Life's a spreadsheet, Excel!
Say thanks, Click *
Wow, Ace - that was quick. I came to reply after getting the email notification and saw that you had already done so.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks