View Single Post
  #1   Report Post  
SMDIYDLI
 
Posts: n/a
Default Adding Subtracting Time Formula-Horse Racing

I would like to create a spreadsheet that will add and subtract time. I'm
using this for horseracing. An example would be to subtract 45² from 1:12³.

I'd be subtracting 45 and two fifths seconds from 1 minute 12 and three fifths
seconds.

I know one way is to enter 72.6 minus 45.4, but I'd like the spreadsheet to do
all the converting if possible.

Can this be done without using a macro?

Thanks for any suggestions.

SMD