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:

=(C4-B4)*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:

=(C4-B4)*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