Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
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 Napolon!

  • Administrator
  • 26,019 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