If end time is in f11 and begin in e11 this formula should do
=F11-E11-TIME(11;0;0)*value(trunc(f11)-trunc(e11))
replace the ; with , if necessary
If end time is in f11 and begin in e11 this formula should do
=F11-E11-TIME(11;0;0)*value(trunc(f11)-trunc(e11))
replace the ; with , if necessary
Last edited by arthurbr; 04-13-2007 at 05:55 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks