Thread: Not clear
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Not clear

You have a response at your other thread.

dkuz wrote:

I was not clear in my question.....

What I want to do is subtract hours from todays date to get a new
date:

For example if today is Feb 14, 2006 and someone has worked 12354 hrs,
and a work day is 7 hours......I want to convert every 7 hrs into a
"day" and subtract the "days" from the current date in order to give me
a date that the person started work. Thanks!

--
dkuz
------------------------------------------------------------------------
dkuz's Profile: http://www.excelforum.com/member.php...o&userid=31536
View this thread: http://www.excelforum.com/showthread...hreadid=512300


--

Dave Peterson