Multiplying time by $ per hour

[Alan]

Hi,

How can you multiply 58:41:00 times $200 per hour?

I guess you have to change the 58:41 into an integer and decimal
format but I don't know how to do that?

Also, if you have a long list of times, what is the best way to check
the addition of those times? Is there a quick way to add the minutes
and the hours separately or turn it all to minutes and then divide by
60?

 

[Don Guillett]

An hour is 1/24th of a day. Try

=R6*24*200

 

[Niek Otten]

And for your 2nd question; just add them. Excel takes care of decimals and minutes. Format as [h]:mm, to show hours over 24.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|
| An hour is 1/24th of a day. Try
|
| =R6*24*200
|
| --
| Don Guillett
| SalesAid Software
| (e-mail address removed)
| | > Hi,
| >
| > How can you multiply 58:41:00 times $200 per hour?
| >
| > I guess you have to change the 58:41 into an integer and decimal
| > format but I don't know how to do that?
| >
| > Also, if you have a long list of times, what is the best way to check
| > the addition of those times? Is there a quick way to add the minutes
| > and the hours separately or turn it all to minutes and then divide by
| > 60?
|
|

 

[Stumac]

To add the times for checking just sum the cells and format the total with
[hh]:mm (you need the square brackets.

Stu

 

[Alan]

Don,

I think you lost me.

I'm doing my time sheets in Excel so the columns are date, start time,
end time, time expended. I add all the times expended down and I come
up with 58:41which is 58.6833333. How do I turn the 58:41 into 58.68?

Alan

 

[Don Guillett]

As I said, multiply your sum by 24...... and then by 200

 

[Zilbandy]

An hour is 1/24th of a day. Try

=R6*24*200

So, using your formula, working one hour at $200/hr, that would come
to 1*24*200 or $4800?

 

[Roger Govier]

No,

As Don said, Excel stores times as fractions of a day, so
1:00 is represented by 0.0416666666666667 internally.

So 0.0416666666666667 x 24 x 200 = 200

 

[Don Guillett]

1 would do that but 1: wouldn't

 

[Zilbandy]

1 would do that but 1: wouldn't

Ok, gotcha. I was looking up something about "1900 date format" the
other day and ran into an article about how excel deals with date and
time formats. Now it all makes since... sort of.

 

[orbii]

not sure if it does it in excel prior 07, but you can use this
=(A1-INT(A1))*24 .... the int will convert from time to decimal. or if you
entered time as text, then you'll have to use left() and right() and mod()
if "12:15" or trunc() and mod() if "12.15" to do the trick.

then converting minutes to deci by math would be minutes/60*100 is that
simple

aloha, orbii