David McRitchie said:Hi Lisa,
Certainly looks like a question that was just asked and in this newsgroup.
See if this helps:
see http://www.mvps.org/dmcritchie /excel/datetime.htm#timediff
If not go through the whole thread:
http://groups.google.co.uk/groups?threadm=60A8070D-E156-4830-A4AF-21DA6F395CC1@microsoft.com
If you do you might note that J.E. McGimpsey offered a choice of two
formulas that provide the same result.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
Lisa said:In military time, how can I take the time a patient entered a clinic, say at
22:20 and find out the time elapsed until they received their antibiotics at
04:00? Thank you!