Excell Time cals - Techist - Tech Forum

Go Back   Techist - Tech Forum > Computer Hardware > Monitors, Printers and Peripherals
Closed Thread
Thread Tools Display Modes
Old 03-24-2005, 01:40 PM   #1 (permalink)
Newb Techie
Join Date: Mar 2005
Posts: 2
Default Excell Time cals

How can I, using Excell muliply a hh:mm formatted cell by a rate of pay in order to get a total cost in £UK
i:e 02:30 * £9.00 = £22.50

Please advise


mavbri is offline  
Old 03-24-2005, 01:42 PM   #2 (permalink)
Ultra Techie
Join Date: Oct 2004
Posts: 874
Send a message via AIM to YanBooth

this post should not be in this forum

XS RULES!!! I have officially referred you.
YanBooth is offline  
Old 03-24-2005, 01:59 PM   #3 (permalink)
True Techie
Join Date: Feb 2005
Posts: 151

If your trying to say they worked 2.5 hours at £9 a hour, you'd be better off just typing that.

Mixing formats such as time and general causes conflicts.
Be not afraid of growing slowly, be afraid only of standing still - Knowledge will get you somewhere, stupidity will get you nowhere
Catbert is offline  
Old 03-24-2005, 02:51 PM   #4 (permalink)
Monster Techie
GrimReaper23's Avatar
Join Date: Feb 2005
Location: Fort Gordon
Posts: 1,912
Send a message via Yahoo to GrimReaper23

Can't you just do the math and then just right in what you get that would then save space and be easier.
GrimReaper23 is offline  
Old 03-25-2005, 05:42 AM   #5 (permalink)
Newb Techie
Join Date: Mar 2005
Posts: 2

Really what I gave was a simply example but some times I have to enter a time of start say 08:35 and a time of finish say 13:22
I then subtract start from finish to give hh:mm which then is multiplied by rate. have I still got to work it out on my calculator? but I was trying to autio the process.


mavbri is offline  
Closed Thread

Thread Tools
Display Modes

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

Our Communities

Our communities encompass many different hobbies and interests, but each one is built on friendly, intelligent membership.

» More about our Communities

Automotive Communities

Our Automotive communities encompass many different makes and models. From U.S. domestics to European Saloons.

» More about our Automotive Communities

Marine Communities

Our Marine websites focus on Cruising and Sailing Vessels, including forums and the largest cruising Wiki project on the web today.

» More about our Marine Communities

Copyright 2002-2015 Social Knowledge, LLC All Rights Reserved.

All times are GMT -5. The time now is 02:33 AM.

Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2016, vBulletin Solutions, Inc.