vzachin
08-27-2009, 07:08 PM
hi,
Paul & Deepak helped me last night
http://www.vbaexpress.com/forum/showthread.php?t=28186
i marked it solved too soon.
i have another question:
In columns G:I are formulas for DAYS,HOURS,MIN. I'm having a problem with the MINUTES
The formula for days is =INT(F4)
The formula for hour is = 24*ROUND((F4-INT(F4)),2)
The formula for minutes = 1440*(F4-INT(F4))
this formula calculates the TOTAL minutes past 60 minutes. if it's 60 minutes, then all i need to show is 1 Hour & 0 minutes
i modified Paul's code to include Round, but i cannot get the minutes to work
=INT(F8)&" days, "&ROUND((24*(F8-INT(F8))),0)&" hour(s),"&ROUND((1440*(F8-INT(F8))),2)&" mins"
please take a look
thanks again
zach
Paul & Deepak helped me last night
http://www.vbaexpress.com/forum/showthread.php?t=28186
i marked it solved too soon.
i have another question:
In columns G:I are formulas for DAYS,HOURS,MIN. I'm having a problem with the MINUTES
The formula for days is =INT(F4)
The formula for hour is = 24*ROUND((F4-INT(F4)),2)
The formula for minutes = 1440*(F4-INT(F4))
this formula calculates the TOTAL minutes past 60 minutes. if it's 60 minutes, then all i need to show is 1 Hour & 0 minutes
i modified Paul's code to include Round, but i cannot get the minutes to work
=INT(F8)&" days, "&ROUND((24*(F8-INT(F8))),0)&" hour(s),"&ROUND((1440*(F8-INT(F8))),2)&" mins"
please take a look
thanks again
zach