time calc

[merkaba22]

Is there a simple way to add, say 30 minutes to a specific time -- for example, for the value "9:30" the calc creates "10:00"?

[Raybaudi]

Hint: a minute contains 60 seconds :)

[Mark Reed]

here is a sample file showing how to accomplish this

timesample.zip

[merkaba22]

That's it -- thanks so much:)

[Lee Smith]

I guess merkaba22 didn't get your hint Daniele.

Your calculation can be expressed as:

YourTimeField + 1800

Lee

Edited June 25, 2010 by Guest

[merkaba22]

These suggestions are great but now I realize one of the reasons my earlier ideas and then these don't work is because the data is in a "time" field but in "military" time; ie. "9:30" is entered as 0930.

Accordingly, I need to be able to have 0930 become 1000 and 1000 become 1030

[Raybaudi]

Can you explain better how exactly you enter data into that time field ?

( because if you enter 0930, you have entered 930 hours )

[merkaba22]

Data is entered military style as "1330" not "1:30" ie., without the colon (":") ... therein lies the difficulty ...

[Raybaudi]

You could type the same time into a text field ( or even into a number field ).

Having 0930 into a time field is the same as having 930:00:00.

BTW: try this calculation:

Time ( Left ( MilitaryField ; 2 ) ; Right ( MilitaryField ; 2 ) + 30 ; 0 )

( format this field to show ONLY hhmm w/o a separator and with leading zero into hours and, from field's behavior, do not give access to this field )