ExcelTip.com
Account Icon Account Icon Account Icon
ExcelTip.com

Go Back   Excel Help Forum > Limelight Media - ExcelTip.com Books > F1 Get the most out of Excel Formulas & Functions

Notices

Reply
 
Thread Tools Search this Thread Rate Thread Display Modes
  #1  
Old 03-29-2006, 10:55 AM
elrosso elrosso is offline
Registered User
 
Join Date: 29 Mar 2006
Posts: 2
elrosso is on a distinguished road
Question som times and codes

I would like to make a small workschedule.

I would like to know how many hours somebody has worked on a location.

Is there a formula who can som the following:

ZHA 8.00 -/- ZHA 17.00 = 9.00

This means started on the location at 8.00 hours and stoped at 17.00 hours. Total working hours 9.

ZHA stands for the code of the location. My schedule needs multiple codes. With these codes I can make a overview to know who will work on the specific location for how many hours.

Hopefully somebody knows the answer or can help me.

thnx in advance
Reply With Quote
Reply

Bookmarks

New topics in F1 Get the most out of Excel Formulas & Functions


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off
Forum Jump


All times are GMT -4. The time now is 03:40 PM.


Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0