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

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.

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.

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.