Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / February 2007

Tip: Looking for answers? Try searching our database.

Total Time Worked - How to Calculate

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Amy - 28 Feb 2007 18:19 GMT
Hello - I am new to the Office Discussion Groups and am despartely looking
for some help.

I have data from a time management system that reports start time and end
time.
I need to calculate what the actual time worked was, which is the difference
between the two. The data is displayed as:
10:45:00 and 6:57:00, each being in a separate cell.
In this particular example, it is saying 10:45am to 6:57pm.

Can anyone help me by providing a formula that would give me the total time
worked? I prefer to have it in minutes if possible.

Thanks for your support.

Signature

Amy

Toppers - 28 Feb 2007 18:43 GMT
A1=Start, B1=Finish

=(B1-A1)*1440

Or
=MOD(B1-A1,1)*1440

The latter allows for times over midnight i.e finish < start

Format cells as general

> Hello - I am new to the Office Discussion Groups and am despartely looking
> for some help.
[quoted text clipped - 10 lines]
>
> Thanks for your support.
Amy - 28 Feb 2007 20:01 GMT
Thank you so much for your help.

Signature

Amy

> Hello - I am new to the Office Discussion Groups and am despartely looking
> for some help.
[quoted text clipped - 10 lines]
>
> Thanks for your support.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.