![]() |
![]() |
|
|||||||
| Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only. |
![]() |
|
|
Thread Tools | Display Modes |
|
|
#1 |
|
Join Date: Mar 2004
Location: Maine
Posts: 1
|
Here's the problem:
I am trying to develop a schedule for my place of buisness. However, I can not figure out a function to display the number of hours worked in a day. Exampe: I want the form to read 8a-9p (to signify when the person is working), but I want it to toatal at the end of the form how many hours that repsresents (it should total 13 hours). I just don't know enough of Excel to figure this one out and I am becoming frustrated. Is there anyone out there who could help me?! I would greatly appreciate it! |
|
|
|
|
|
#2 |
|
Join Date: Feb 2004
Posts: 198
|
Welcome to the board!
Try this: If your time in is 8:00 am [A1] and your time out is 9:00 pm [B1], then in [C1] enter this formula: =abs(b1-c1)*24 This will turn the time difference into hours. note, if they work 3 hours and 20 minutes, it will show up as 3.33 (20 minutes equaling 1/3 of one hour.) Please let me know if this is the result you want. -Jarrod |
|
|
|
|
|
#3 | |||||||||||||||||||||||||||||||||||||
|
Join Date: Feb 2002
Posts: 7,599
|
Quote:
http://www.cpearson.com/excel/overtime.htm Here's an example. C15 is custom formatted as [h]:mm, D15 as a number ******** ******************** ************************************************************************>
[HtmlMaker light Ver1.10] To see the formula in the cells just click on the cells hyperlink or click the Name box PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR. If your times run over to the next day, use =B15-A15+(B15 |
|||||||||||||||||||||||||||||||||||||
|
|
|
|||||||||||||||||||||||||||||||||||||
|
|
#4 |
|
Join Date: Jan 2003
Location: Round Rock, Texas
Posts: 564
|
Hi Aimie,
If neither Jarrod's nor Brian's post helps, take a look at this post: http://www.mrexcel.com/board2/viewtopic.php?t=54828 and see if it is similar to your situation. If so, the formulas (on the 2nd page, next to last post) can be tailored for you . . . |
|
|
|
![]() |
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|