Skip to main content

Unsolved

This post is more than 5 years old

bahir

18 Posts

2827

February 25th, 2000 02:00

excel-2000

can anyone tells me the excel formula for multipling total hours into dollar amount .for example 43hrs30mins into$6.25 .i am trying to make payroll formula .i have alreadymade formula for how to bring total number of hours.but can't make the ultimate one (total hours*$6.25).is there anybody who has a greater knowledge about excel ?i'll precite your big help. thanks in advance

Erik1

837 Posts

February 25th, 2000 02:00

If I understand you correctly, I do not believe it can be done. Excel would interpret 43hrs30mins as text. Is there some way you can get your cell to display 43.5 instead?

Erik
B3JR9, UKMBH & 07C0D

Was this post helpful?

View All

0 events found

No Events found!

Top