View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RER RER is offline
external usenet poster
 
Posts: 1
Default 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.