View Single Post
  #2   Report Post  
Trevor Shuttleworth
 
Posts: n/a
Default

if the fields have times in them as they appear, just add them like any
other cells and format as mm:ss or hh:mm:ss

Regards

Trevor


"Bjarne Hansen" wrote in message
. ..
Hi

I'm a little new in Excel, I need some help
with at sheet, that are able to calculate time
something like this:

text1 3:30 (3 min 30 sec)
text2 2:10 3:40 (result of text1 and test2)
text3 1:40 8:20 (result of text1, 2 and 3)
total 7:20

Thanks in advance