Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I subtract one time from another to get OT worked?
I am trying to design a simple excel spreadsheet that will calculate overtime
worked. I want it to display similar to this. The spreadsheet would hopefully be a template and password protected, so all one would have to do is fill in the blanks. Sunday 13:30 17:30 4 Monday 17:00 18:00 1 Tuesday 17:00 17:30 .5 etc TOTAL 5.5 Any suggestions, as I am stymied on how to do this. I am using Excel 2003. Thanks. |
#2
|
|||
|
|||
See:
http://www.cpearson.com/excel/overtime.htm Regards, Peo Sjoblom "Michele" wrote: I am trying to design a simple excel spreadsheet that will calculate overtime worked. I want it to display similar to this. The spreadsheet would hopefully be a template and password protected, so all one would have to do is fill in the blanks. Sunday 13:30 17:30 4 Monday 17:00 18:00 1 Tuesday 17:00 17:30 .5 etc TOTAL 5.5 Any suggestions, as I am stymied on how to do this. I am using Excel 2003. Thanks. |
#3
|
|||
|
|||
Hi
try =(B1-A1)*24 -- Regards Frank Kabel Frankfurt, Germany "Michele" schrieb im Newsbeitrag ... I am trying to design a simple excel spreadsheet that will calculate overtime worked. I want it to display similar to this. The spreadsheet would hopefully be a template and password protected, so all one would have to do is fill in the blanks. Sunday 13:30 17:30 4 Monday 17:00 18:00 1 Tuesday 17:00 17:30 .5 etc TOTAL 5.5 Any suggestions, as I am stymied on how to do this. I am using Excel 2003. Thanks. |
#4
|
|||
|
|||
Format all the cells involving times the same way (including the cell that
holds the calculation). For example, select the cells containing the data, go to FormatCellsNumber then select 'Time' from the category section then choose 13:30 from the 'Type' section. Then go back to your spreadsheet and use a simple subtraction of the 2 cells. A1 B1 C1 13:30 17:30 =B1-C1 You should see 4:00 as your answer. :) "Michele" wrote: I am trying to design a simple excel spreadsheet that will calculate overtime worked. I want it to display similar to this. The spreadsheet would hopefully be a template and password protected, so all one would have to do is fill in the blanks. Sunday 13:30 17:30 4 Monday 17:00 18:00 1 Tuesday 17:00 17:30 .5 etc TOTAL 5.5 Any suggestions, as I am stymied on how to do this. I am using Excel 2003. Thanks. |
#5
|
|||
|
|||
Thanks so much. I appreciate the link. It will be every helpful. BTW, This
is the first time I've ever used a "Discussion Group." I think I'll use more often when I have problems like this. Again thanks for the help. "Peo Sjoblom" wrote: See: http://www.cpearson.com/excel/overtime.htm Regards, Peo Sjoblom "Michele" wrote: I am trying to design a simple excel spreadsheet that will calculate overtime worked. I want it to display similar to this. The spreadsheet would hopefully be a template and password protected, so all one would have to do is fill in the blanks. Sunday 13:30 17:30 4 Monday 17:00 18:00 1 Tuesday 17:00 17:30 .5 etc TOTAL 5.5 Any suggestions, as I am stymied on how to do this. I am using Excel 2003. Thanks. |
#6
|
|||
|
|||
Michelle
Chip Pearson has done all the work for you. See http://www.cpearson.com/excel/overtime.htm Gord Dibben Excel MVP On Thu, 2 Dec 2004 11:43:03 -0800, "Michele" wrote: I am trying to design a simple excel spreadsheet that will calculate overtime worked. I want it to display similar to this. The spreadsheet would hopefully be a template and password protected, so all one would have to do is fill in the blanks. Sunday 13:30 17:30 4 Monday 17:00 18:00 1 Tuesday 17:00 17:30 .5 etc TOTAL 5.5 Any suggestions, as I am stymied on how to do this. I am using Excel 2003. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help - Information with time and date | Excel Discussion (Misc queries) | |||
time sheet | Excel Worksheet Functions | |||
Subtract Decimal time | Excel Worksheet Functions | |||
time formatting and time categorizing (vlookup or data validation) | Excel Worksheet Functions | |||
how do you subtract military time? example 12:00 - 07:00 = 5 hour. | Excel Worksheet Functions |