Jump to content

Welcome to Geeks to Go - Register now for FREE

Need help with your computer or device? Want to learn new tech skills? You're in the right place!
Geeks to Go is a friendly community of tech experts who can solve any problem you have. Just create a free account and post your question. Our volunteers will reply quickly and guide you through the steps. Don't let tech troubles stop you. Join Geeks to Go now and get the support you need!

How it Works Create Account
Photo

Excel query - please help!


  • Please log in to reply

#1
Gnattle

Gnattle

    New Member

  • Member
  • Pip
  • 3 posts
Hi,

I am a newbie to here! :help:

I am doing a report in Excel basically to do with time and money.

Anyway I need a forumla which allows me to times the amount of minutes by a cost. However I have had to format the time cells as there is large amount of time.

At the mo just using a basic formula for 98 minutes(which is several columns added up for this month for example) by £1.42 it is giving me £5.80 which is wrong! :whistling:

Any help much appreciated. Its been driving me mad! :blink:
  • 0

Advertisements


#2
dsenette

dsenette

    Je suis Napoléon!

  • Community Leader
  • 26,047 posts
  • MVP
http://www.exceltip...._Values/96.html
http://exceltips.vit...l_Notation.html

http://www.computing.../forum/416.html

a few references on converting time notation to decimal
  • 0

#3
Gnattle

Gnattle

    New Member

  • Topic Starter
  • Member
  • Pip
  • 3 posts
Hiya,

Thanks the links, but not quite what I am after, I am crap at explaining myself. :whistling:

I will search on the sites you linked to and see if I can find anything.

I know its possible!
  • 0

#4
piper

piper

    Retired Staff

  • Retired Staff
  • 2,459 posts
Format the time fields at time. Format the field that calculates total time worked at Custom h:mm. The key is the formula for calculating total time by the rate.

A1 8:00am (clock in time - A1 through D1 formatted as Time 1:30 pm)
B1 12:00pm (clock out time)
C1 1:00pm (clock in time)
D1 2:30pm (clock out time)
E1 =D1-C1+B1-C1 -> the result is 5:30 (total time worked - formatted Custom - h:mm)
F1 $18.50 (hourly rate - formatted as currency)
G1 =E1*F1*24 -> the result is $101.75, which is correct

Is this close to what you need?
  • 0

#5
Gnattle

Gnattle

    New Member

  • Topic Starter
  • Member
  • Pip
  • 3 posts
Kind off.

The difficulty i was having is majority of the fields were over 24 hours - anything up to 12,000 hours so needed a certain format.

I have is sussed now though thanks to the links above! :blink:

Just needed to do =SUM(E5*85.00)*24 - E5 being the added up total at the end of the colum i.e 39 hours.

Thanks I had just given a bad example. :whistling:
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP