Excel Formulas

Hi EnB,

Was that you as Guest earlier with identical question? I am sure you will have improved responses now you have shown your registration.

For your time data entry cells F2 & G2, Format as Time HH:MM:SS. The time duration difference H2 is simply cell formula; =sum(G2-F2). Format cell H2 the same as cells F2 & G2.

The % per day, cell J2, is; =sum(H2/24) with the cell formatted as Percentage. i.e. Menu Format/Cell/Number/Percentage.

Date A - Date B gives the difference in days.

Time A - Time B gives the time difference in a fraction of a day (can be negative).

Date A - Date B + Time A - Time B gives difference in days. Store in general format.

For difference in hours, multiply by 24.

For difference in minutes, multiply by 24*60.

For difference in seconds, multiply by 24*3600.

Hi EnB,

Here's a step-by-step, how-to-do-it:

1. Click on Cell H2.

2. Type everything inside the quotes: "=(G2-F2)". Press Enter.

3. Right Click on Cell H2 again, and format the cell to your desired format.

4. Click on Cell J2.

5. Type "=(H2/(24*60*60))*100" and press Enter.

DONE! You can simply copy the cell to the rest of the cells below it in the column to calculate the other values you may have in the rows beneath.

Hope that helps.

This may help:-

http://office.microsoft.com/training/training.aspx?AssetID=RP061771091033&CTT=6&Origin=RC061771061033