Eric Aldinger

I would use two fields, one date and one with a custom time format of
mm:ss. You can also do a custom type of mm/dd/yyyy hh:mm:ss where hours
would be 0
On Oct 10, 2013 1:06 PM, "Mike Murray" wrote:

> Candi meant to say that it is putting it in as h:mm:ss when the pasted
> date is mm:ss. The minutes are going in the hour spot.
> Mike Murray - Sent via BlackBerry from T-Mobile
>
> -----Original Message-----
> From: "Candi Murray"
> Sender: obra-bounces@list.obra.org
> Date: Thu, 10 Oct 2013 12:34:15
> To:
> Reply-To: cmurray@obra.org
> Subject: [OBRA Chat] OT-Excel Help
>
> _______________________________________________
> OBRA mailing list
> obra@list.obra.org
> http://list.obra.org/mailman/listinfo/obra
> Unsubscribe: obra-unsubscribe@list.obra.org
>
>
> _______________________________________________
> OBRA mailing list
> obra@list.obra.org
> http://list.obra.org/mailman/listinfo/obra
> Unsubscribe: obra-unsubscribe@list.obra.org
>

Brian Ratliff

I think after you import the data into excel, you can divide each entry by
60 and it'll come out the way you want. You'll get decimal minutes rather
than minutes + seconds though.

Brian

On Thu, Oct 10, 2013 at 1:05 PM, Mike Murray wrote:

> Candi meant to say that it is putting it in as h:mm:ss when the pasted
> date is mm:ss. The minutes are going in the hour spot.
> Mike Murray - Sent via BlackBerry from T-Mobile
>
> -----Original Message-----
> From: "Candi Murray"
> Sender: obra-bounces@list.obra.org
> Date: Thu, 10 Oct 2013 12:34:15
> To:
> Reply-To: cmurray@obra.org
> Subject: [OBRA Chat] OT-Excel Help
>
> _______________________________________________
> OBRA mailing list
> obra@list.obra.org
> http://list.obra.org/mailman/listinfo/obra
> Unsubscribe: obra-unsubscribe@list.obra.org
>
>
> _______________________________________________
> OBRA mailing list
> obra@list.obra.org
> http://list.obra.org/mailman/listinfo/obra
> Unsubscribe: obra-unsubscribe@list.obra.org
>

Mike Murray

Candi meant to say that it is putting it in as h:mm:ss when the pasted date is mm:ss. The minutes are going in the hour spot.
Mike Murray - Sent via BlackBerry from T-Mobile

-----Original Message-----
From: "Candi Murray"
Sender: obra-bounces@list.obra.org
Date: Thu, 10 Oct 2013 12:34:15
To:
Reply-To: cmurray@obra.org
Subject: [OBRA Chat] OT-Excel Help

_______________________________________________
OBRA mailing list
obra@list.obra.org
http://list.obra.org/mailman/listinfo/obra
Unsubscribe: obra-unsubscribe@list.obra.org

Candi Murray

My timing module for the ccx program is putting times out mm:ss:00 instead
of mm:ss.00. Because of this they do not post well. All of the usual methods
for reformatting this are not working. Including pasting it in Word and
trying to put it back in a text file. Anyone know any tricks?

Candi