Convert payroll hours to decimal

[amxtomzo]

hello and thanks for helping

I am trying to convert payroll hours to decimal,
getting stuck when hours are over 24

example
DATA in cell A1 = 30:30
would like end result in cell B1 to = 30.5

this formula is only good up to 24 hours
" =(A1-INT(A1))*24 "

i am open to new ideas on this

thanks

Thomas

 

[VBA Geek]

If you just multiply 30:30 by 24 you would get 30.5

 

[amxtomzo]

Awesome

Quote from my shop teacher 100 years ago: " Simplicity is your best design"

thank you very much, have a GREAT day

Thomas