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

Hospoguy76 · #1 08-25-2018, 11:50 PM

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 · #2 08-27-2018, 06:17 AM

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

Logit · #3 08-27-2018, 06:57 PM

.
Paste in Routine Module :

Code:

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Autosave every 1 Minute	JanTrummel	Visio	1	05-22-2017 09:10 AM
time in minute format	orajesh	Excel	3	12-15-2015 12:56 AM
Time allotted minus time used with result in hour and minute	esther6086	Excel	2	04-29-2014 05:03 PM
How to obtain the inverse tan of a value in degree/minute second?	Jamal NUMAN	Excel	3	07-27-2013 10:18 AM
Run a macro each minute?	yabbah	Excel Programming	5	05-31-2012 01:01 AM