Payment Calculations based on
Timestamps


Excel 2007  Excel 2003  Macros Excel 2007  Macros Excel 2003  Excel 2010 





The user enters the
start timestamp
and the end timestamp and the rate per hour or minute and based on this
data you can quickly and easily calculate the payment or total amount
due using a sinple formula. Timestamp just means that you enter the date and time in one shot in the relevant Excel worksheet cell. Excel treats the date as an integer and the time as a fraction. You enter the timestamp as '04/15/2012 9:00' which means '15th April 2012 9 am'. Once you've entered both the 'start' and 'end' timestamps you can calculate the total amount or total payment as shown in the video. Formula entered in cell E4 to calculate amount: =(C4B4)*24*D4 C4=End Timestamp B4=Start Timestamp 24 = total number of hours in a day D4= hourly rate If the rate is per minute then the formula would be: =(C4B4)*24*60*D4 Watch the Excel training video below to learn how to use timestamps in Microsoft Excel to calculate the payments: 



Excel 2007  Excel 2003  Macros Excel 2007  Macros Excel 2003  Excel 2010 
