I'm trying to calculate mixed formats like currency * time
If I worked 9:22 today and my hr rate is $23.00/hr
how do I do this?
Mark
I'm trying to calculate mixed formats like currency * time
If I worked 9:22 today and my hr rate is $23.00/hr
how do I do this?
Mark
Hi Mark
i'm assuming 9:22 is 9 hours and 22 minutes of work, if so the formula would
be
(with 9:22 in A1 and $23 in B1)
=A1*24*B1
and format this answer as a number
Cheers
JulieD
"Mark" <[email protected]> wrote in message
news:[email protected]...
> I'm trying to calculate mixed formats like currency * time
> If I worked 9:22 today and my hr rate is $23.00/hr
> how do I do this?
>
> Mark
On Fri, 1 Apr 2005 00:46:19 +0800, "JulieD"
<[email protected]> wrote:
>Hi Mark
>
>i'm assuming 9:22 is 9 hours and 22 minutes of work, if so the formula would
>be
>(with 9:22 in A1 and $23 in B1)
>=A1*24*B1
>and format this answer as a number
>
>Cheers
>JulieD
>
>"Mark" <[email protected]> wrote in message
>news:[email protected]...
>> I'm trying to calculate mixed formats like currency * time
>> If I worked 9:22 today and my hr rate is $23.00/hr
>> how do I do this?
>>
>> Mark
>
thanks JulieD
works fine
Mark
you're welcome and thanks for the feedback
"Mark" <[email protected]> wrote in message
news:[email protected]...
> On Fri, 1 Apr 2005 00:46:19 +0800, "JulieD"
> <[email protected]> wrote:
>
>>Hi Mark
>>
>>i'm assuming 9:22 is 9 hours and 22 minutes of work, if so the formula
>>would
>>be
>>(with 9:22 in A1 and $23 in B1)
>>=A1*24*B1
>>and format this answer as a number
>>
>>Cheers
>>JulieD
>>
>>"Mark" <[email protected]> wrote in message
>>news:[email protected]...
>>> I'm trying to calculate mixed formats like currency * time
>>> If I worked 9:22 today and my hr rate is $23.00/hr
>>> how do I do this?
>>>
>>> Mark
>>
> thanks JulieD
> works fine
>
> Mark
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks