TIme

[Aimie]

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!

[jcvoth]

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

[Brian from Maui]

Originally Posted by Aimie

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!

A good place to start is here,

http://www.cpearson.com/excel/overtime.htm

Here's an example. C15 is custom formatted as [h]:mm, D15 as a number

******** ******************** ************************************************************************>

Microsoft Excel - Book1 ___Running: 11.0 : OS = Windows XP
File Edit View Insert Options Tools Data Window Help About
C15D15 =
	A	B	C	D
15	8:00*AM	9:00*PM	13:00	13.00
Sheet1 *

[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

[rrdonutz]

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 . . .