FORMULA FOR TIME
 

Hello! : )

I am also looking for a formula that can help me calculate hours worked
by adding start and end times.Also I would like for it to subtract 30 minutes
for lunch from monday to thursday. I would like it to calculate the time by
1/4 hours with 8 minutes being the up or down trigger.

For Example:
1) Example down START @ 8:00 END @16:37=9 hours
2) Example up START @8:00 End @ 16:38=9 hours & 15 minutes

Someone please help me for i have worked on this days now. : (

THANKX,
R.E.R.

FORMULA FOR TIME
 

1) Example down START @ 8:00 END @16:37=9 hours
2) Example up START @8:00 End @ 16:38=9 hours & 15 minutes

How do you arrive at those results?

Example 1 total time is 8:37 rounded to the nearest 15m = 8:30
Example 2 total time is 8:38 rounded to the nearest 15m = 8:45

A2 = 8:00
B2 = 16:37

=ROUND((B2-A2)/TIME(0,15,0),0)*TIME(0,15,0)

Biff

"RER" wrote in message
...
Hello! : )

I am also looking for a formula that can help me calculate hours
worked
by adding start and end times.Also I would like for it to subtract 30
minutes
for lunch from monday to thursday. I would like it to calculate the time
by
1/4 hours with 8 minutes being the up or down trigger.

For Example:
1) Example down START @ 8:00 END @16:37=9 hours
2) Example up START @8:00 End @ 16:38=9 hours & 15 minutes

Someone please help me for i have worked on this days now. : (

THANKX,
R.E.R.

FORMULA FOR TIME
 

The OP ssems to have added half an hour for lunch, rather than subtracting
it?
--
David Biddulph

"T. Valko" wrote in message
...
1) Example down START @ 8:00 END @16:37=9 hours
2) Example up START @8:00 End @ 16:38=9 hours & 15 minutes

How do you arrive at those results?

Example 1 total time is 8:37 rounded to the nearest 15m = 8:30
Example 2 total time is 8:38 rounded to the nearest 15m = 8:45

A2 = 8:00
B2 = 16:37

=ROUND((B2-A2)/TIME(0,15,0),0)*TIME(0,15,0)

Biff

"RER" wrote in message
...
Hello! : )

I am also looking for a formula that can help me calculate hours
worked
by adding start and end times.Also I would like for it to subtract 30
minutes
for lunch from monday to thursday. I would like it to calculate the time
by
1/4 hours with 8 minutes being the up or down trigger.

For Example:
1) Example down START @ 8:00 END @16:37=9 hours
2) Example up START @8:00 End @ 16:38=9 hours & 15 minutes

Someone please help me for i have worked on this days now. : (

THANKX,

R.E.R.