PC Review


Reply
Thread Tools Rate Thread

How to change hours and minutes to calculate charges?

 
 
=?Utf-8?B?RS4gTGV3aXM=?=
Guest
Posts: n/a
 
      21st Sep 2007
I am trying to set up an excel worksheet to calculate and charge for time
spent by computer users.

Can anyone help me?

E. Lewis
 
Reply With Quote
 
 
 
 
Pete_UK
Guest
Posts: n/a
 
      21st Sep 2007
If you have a start time in A1 and a finish time in B1 (in Excel time
format), then the time difference (in C1) is:

=B1-A1

If you have an hourly rate in D1, then this is the charge (in E1):

=C1*D1*24

Format this cell as currency.

Hope this helps.

Pete

On Sep 21, 9:20 am, E. Lewis <E. Le...@discussions.microsoft.com>
wrote:
> I am trying to set up an excel worksheet to calculate and charge for time
> spent by computer users.
>
> Can anyone help me?
>
> E. Lewis



 
Reply With Quote
Reply

Thread Tools
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 On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculate Days, Hours, Minutes Scott Microsoft Access 1 22nd Oct 2009 03:53 PM
formula calculate charges based on hours =?Utf-8?B?UGFtbXk=?= Microsoft Excel Misc 1 4th Sep 2007 07:54 PM
how to calculate the hours and minutes in excel =?Utf-8?B?TWl0YWw=?= Microsoft Excel Misc 3 14th Feb 2006 06:49 PM
calculate average hours and minutes =?Utf-8?B?bGxzdGVwaGVucw==?= Microsoft Excel Worksheet Functions 4 30th Nov 2004 03:47 PM
Re: Calculate Hours and Minutes Allen Browne Microsoft Access Forms 3 28th Jul 2003 06:25 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:40 PM.