Billiable Time (1st hr and subsequent)

[synny]

Gd day All,

New in here. Been scouring for a fit of formula to solve my problem, to no avail of course.
What I would like to have is to have a 1st hour Charge @ 1st hour rate and the subsequent hours to be charge at another rate.

One column i had done is =CEILING(N8,"0:30") (this is to round of all the extra mins to 00/30mins) and thus its easier to breakdown to another 1 hour and the rest of the hours.

Attached for you kind reference. Those column in colours are my blank ideas.

Thank again.

[sourabhg98]

In O8 I think you should use this instead-

Please Login or Register  to view this content.

Copy down

and now in R8 try this-

Please Login or Register  to view this content.

Copy down..
Note- It is calculated on the basis of amended rate.

[Pepe Le Mokko]

Like this ?

[synny]

sigh of relief to receive your reply..
it works well... one last query.

for the subsequent hours, if I were to charge it based on block of 30mins (ie; if 2 hrs = 4 units, means 4 units x $ instead of (2hrs x $ )

any possibility?

[synny]

Like this ?

thank you! just like the kind gentleman @sourabhg98 provides.
and i had the same query as above..

"quote:for the subsequent hours, if I were to charge it based on block of 30mins (ie; if 2 hrs = 4 units, means 4 units x $ instead of (2hrs x $ ).
Thanks1