Hi
I have a sheet which works out how many hours it takes to produce a part, but because its using multiplication and division, my sum is coming back as a number. i.e. 8.68 hours, if i put a start time in for a job say 07:00:00 and i want to add the 8.68 hours to it, how can i do this to return 15:40:00
Any hep would be great
Try = "07:00:00"+8.68/24 and format as needed
Excellent thats spot on, thank you very much
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks