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

		Microsoft Office Forums > Microsoft Excel > Excel
How to calculate wait time eg. minute(s) to AU$ where 1 minute is 10 cents

FAQ

Thread Tools

Display Modes

08-27-2018, 06:57 PM

Logit

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

Office 2007

Expert

Join Date: Jan 2017

Posts: 591

.
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

Attached Files

Wait Time Charges.xlsm (17.0 KB, 11 views)

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 04:23 AM.