Time sheet entries

Jeaneb

New Member
Joined
Oct 11, 2002
Messages
1
How do you add and subtract time entries.
ex: Employee starts at 10:00 am and works until 6:15 pm. Total hours for that day?
 

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

plettieri

Well-known Member
Joined
Sep 4, 2002
Messages
1,556
Platform
  1. MacOS
Hello Jeaneb and welcome to the board

A little understanding of the way excel handles time is important see ...http://www.ozgrid.com/Excel/ExcelDateandTimes.htm


Are you looking to do something like this...

Format your cells custom h:mm
formular samples.xls
ABCDEFG
1
2
3
4Start10:00
5Finishtime18:15
6diff8:15
7
8
time ref



hope this helps

pll
 

Lawnman

New Member
Joined
Oct 11, 2002
Messages
10
Jeaneb
I just enter times directly.

A1cell- 10:00 am
A2cell- 11:00 am
A3cell- =a2-a1
in cell a3 you may get a decimal # if you do go to cell format and change the cell format
Also make sure you add space between the last # and the AM or PM, or it will not work
Dennis
 

cblincoln43

Board Regular
Joined
Mar 12, 2002
Messages
206
Got e-mail send to cblincoln43@yahoo.com, Will send working time sheet you can work with. OH! lable it time sheet.
Thanks to the fine folks on this board.
Bob, cblincoln
This message was edited by cblincoln43 on 2002-10-13 01:14
 

Forum statistics

Threads
1,143,640
Messages
5,719,986
Members
422,256
Latest member
downeybm

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top