So I have a long list (doing this manually is not possible) of military time ( 8:00 A is 800 , 2:00PM is 1400 , 4:40P is 1640 )
I have two columns (one a start time , and one an ending time )
I want a third column that computes the minutes elapsed from those two.
Any help is appreciated. Thanks.
I should try googling first next time, sorry.
--
Use the DOLLARDE function as shown in the following formula:
=DOLLARDE(B2/100,60)-DOLLARDE(A2/100,60)
AlternatelyOriginally Posted by pink
=B2-A2
with the formula cell (C2) formatted to [mm]
hth
---
Last edited by Bryan Hessey; 02-13-2007 at 03:05 AM.
Si fractum non sit, noli id reficere.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks