dollars and times

[scott]

i am trying to create a employee schedule using the
schedule in hours formating. I need to compare the total
hours with a budget. The budget is in genral number and
dollar formats and the schedule is in hour format so how
do i set it up or convert hours in to dollars or general
number and vice versa.

Ex:

if i have scheduled hours of 1290:00<---hours
but budgeted hours of 1190.00<---general number or
dollars
it would tell me (100.00) or
(100:00)

any help would be great.

scott

 

[Norman Harker]

Hi Scott!

With time in A1 and dollars per hour in B1

=A1*24*B1

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.