If 4:00 (in time format) is in a1, then in a2 you could put hour(a1) to get 4 (make sure its general or number format).
Might help get you started.
"falco886 " wrote in message ...
i am trying to make a time sheet were i need to multiply total hours by
a dollar amount. can't seem to get it running.what i need is the
formula and what format to use. converting hours and minutes to any
other format messes things up
---
Message posted from
http://www.ExcelForum.com/