View Full Version : help making an excel spreadsheet
17th November 2003, 12:40 PM
i'm trying to make a simple spreadsheet where in one cell i can type in the time an employee starts, in another cell the time they finish and have the hours worked pop up in a third cell (automatically deducting one half hour for lunch break)
example. cell 1a, i type in 6:50
cell 2a, i type in 3:20
and voila in cell 3a it will read: 8.00 hours
if anybody can help i'd really appreciate it!!!
17th November 2003, 12:59 PM
put 6:50 in A1
put 15:20 (or 3:20 pm) in B1
put =B1-A1-TIME(0,30,0) in C1
C1 will display the hours.
You will probably have to adjust the formats of the cell so the times show up correctly. If you follow the example above, C1 will probably display 1/1/1970 8:10 or something.Select the entire column or row, Format...Cells.., select time, and then the formatting that you want for the time.
edited because I figured out something obvious.
edited to point out that you can also use "0:30" (with the quotations) in the equation instead of the TIME function.
17th November 2003, 01:03 PM
And, this help topic from excel is useful for knowing how to input time:
The 12-hour or 24-hour clock To type a time based on the 12-hour clock, type a space followed by AM or PM (or A or P) after the time. Otherwise, Excel bases the time on the 24-hour clock. For example, if you type 3:00 instead of 3:00 PM, the time is stored as 3:00 AM
17th November 2003, 05:05 PM
17th November 2003, 06:26 PM
[john wayne]anytime, pilgrim[/john wayne]
© 2001-2009, James Randi Educational Foundation. All Rights Reserved.
vBulletin® v3.7.7, Copyright ©2000-2013, Jelsoft Enterprises Ltd.