Thread: Can i get a formula to change hours into currency £
View Single Post
  #3  
Old May 17th, 2009, 11:34 PM posted to microsoft.public.excel.misc
FSt1
external usenet poster
  
Posts: 2,788
Default Can i get a formula to change hours into currency £
hi
with 78:30:00 in A2.....
=(A2*24)*6
format as currency.

regards
FSt1

"David Wilson" wrote:

I am looking for a formula to change working hours i.e (78h 30m ) into
currency i.e
£6.00 £6.00 x 78:30 ( h:mm ) = £471.00

Excel 2007