if i want to calculate the working hr from 9:00am to 6:00pm in a column
A Allen Browne Aug 27, 2004 #2 See: Calculating elapsed time at: http://members.iinet.net.au/~allenbrowne/casu-13.html It explains how to use DateDiff() to get the difference in minutes, and format the result as hours and minutes.
See: Calculating elapsed time at: http://members.iinet.net.au/~allenbrowne/casu-13.html It explains how to use DateDiff() to get the difference in minutes, and format the result as hours and minutes.
