calculating time
I am working in excel i want to put in a start time and an end time i want
for mon thru fri 7:00 am to 3:30 pm to be reg hours and any time before or after to be ot I also want to add a luch column and to put in if there is a lunch how much time was taken for lunch then i want it to calculate reg and ot taking out a lunch if there is one taken - ANY HELP WOULD BE GREATLY APPRECIATED |
calculating time
E-QUIP wrote: I am working in excel i want to put in a start time and an end time i want for mon thru fri 7:00 am to 3:30 pm to be reg hours and any time before or after to be ot I also want to add a luch column and to put in if there is a lunch how much time was taken for lunch then i want it to calculate reg and ot taking out a lunch if there is one taken - ANY HELP WOULD BE GREATLY APPRECIATED Just enter time as 07:00 in A1 cell and 15:30 in A2 and give a formula IN A3 as A2-A1. make sure the cell A3 is formatted as hh:mm with FormatcellsNumber menu. Similarly you can put date and time both in the same cell by formatting cell as dd-mm-yyyy hh:mm in both A1 & A2 and in A3 write formula as (A2-A1)*24 and format as number with one or two decimal places as you require. Hope this is useful. I am actually using such a spreadsheet to calculate OT of my department. Regards. |
calculating time
I wanted to use standard time not military also, can it calculate it to
figure any time before or after the 7:00am to 3:30pm to be overtime? "Manju" wrote: E-QUIP wrote: I am working in excel i want to put in a start time and an end time i want for mon thru fri 7:00 am to 3:30 pm to be reg hours and any time before or after to be ot I also want to add a luch column and to put in if there is a lunch how much time was taken for lunch then i want it to calculate reg and ot taking out a lunch if there is one taken - ANY HELP WOULD BE GREATLY APPRECIATED Just enter time as 07:00 in A1 cell and 15:30 in A2 and give a formula IN A3 as A2-A1. make sure the cell A3 is formatted as hh:mm with FormatcellsNumber menu. Similarly you can put date and time both in the same cell by formatting cell as dd-mm-yyyy hh:mm in both A1 & A2 and in A3 write formula as (A2-A1)*24 and format as number with one or two decimal places as you require. Hope this is useful. I am actually using such a spreadsheet to calculate OT of my department. Regards. |
calculating time
What you can do is assume COLUMN A is start time, COLUMN B is end
time, COLUMN C as regular time, COLUMN D as overtime. then format the cells under column A and column B as dd-mm-yyyy h:mm AM/PM and COLUMN C as number with two decimal with a formula (B1-A1)*24. column D as number with two decimal with a formula (C-8.50) there are other ways available to change 0.5 to 30 minutes. try this Regards. E-QUIP wrote: I wanted to use standard time not military also, can it calculate it to figure any time before or after the 7:00am to 3:30pm to be overtime? "Manju" wrote: E-QUIP wrote: I am working in excel i want to put in a start time and an end time i want for mon thru fri 7:00 am to 3:30 pm to be reg hours and any time before or after to be ot I also want to add a luch column and to put in if there is a lunch how much time was taken for lunch then i want it to calculate reg and ot taking out a lunch if there is one taken - ANY HELP WOULD BE GREATLY APPRECIATED Just enter time as 07:00 in A1 cell and 15:30 in A2 and give a formula IN A3 as A2-A1. make sure the cell A3 is formatted as hh:mm with FormatcellsNumber menu. Similarly you can put date and time both in the same cell by formatting cell as dd-mm-yyyy hh:mm in both A1 & A2 and in A3 write formula as (A2-A1)*24 and format as number with one or two decimal places as you require. Hope this is useful. I am actually using such a spreadsheet to calculate OT of my department. Regards. |
All times are GMT +1. The time now is 09:25 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com