How to calculate wait time eg. minute(s) to AU$ where 1 minute is 10 cents

[Hospoguy76]

I am starting up my own passenger transport business and have got everything else put into a spreadsheet to help me work out the fare but I am struggling to work out a formula for working out wait time in case passenger isn't ready or wants me to wait at a destination whilst they run an errand etc.

[NBVC]

Perhaps post a sample workbook detailing what you have and what you need.

[Logit]

.
Paste in Routine Module :

Option Explicit

Sub StartDateTime()
    Sheets("Sheet1").Range("A4").Value = Now
End Sub

Sub EndDateTime()
    Sheets("Sheet1").Range("B4").Value = Now
End Sub

Sub ClearDateTime()
    Sheets("Sheet1").Range("A4").Value = ""
    Sheets("Sheet1").Range("B4").Value = ""
End Sub

See attached workbook