Please help, I have 4 field date and time from and date and time to

This the sample format 4pm 07/07/05  and  8pm 07/08/15

 

 

 

Assuming you want to calculate the elapsed time, make the calculation =

Timestamp ( DateTo ; TimeTo ) - Timestamp ( DateFrom ; TimeFrom ) 

and set the result type to Time.

Thanks it works. This is exactly what i need.

I have a previous post here about this but i deleted it because of confusion. The calculation @comment provide me is working but i have a problem, I am not sure if its on relationship or calculation field of the date and time. I attach the example data. In task layout record 2 as you see the hours to complete is 24 so when i start at 6:AM of feb 16 it suppose to end at 6:AM feb 17. In View layout it should show but it is not appearing when i select the date of Feb 16. I also notice when i add record that exceeds at 12:AM it is not showing.

Task Scheduling.fmp12

Edited February 17, 201610 yr by chadski021
change table to layout

I'm not seeing the issue. What version of FM are you using?

 

 

two versions 13 and 14.

Here is the screenshot

 

Edited February 17, 201610 yr by chadski021

Ok, let's make sure you have the lingo right.  When you mentioned "view table" I assumed  you meant "table view".  So be clear to let us know what layout you are seeing or not seeing something.

Ow sorry not table i mean layout.

Just to follow on this.

Edited February 18, 201610 yr by chadski021

it's because your time end (even though on a different date) is not greater than 6am, so the relationship from the 7am and later timeslots is not valid.

You'd be better off using a timestamp field for the relationship instead of separate date and time fields.  The end-time field does not know it belongs to the next day...

What will happen is that i will create start timestamp and end timestamp is that correct?

How about the relationship on the Date global fields?

you wouldn't need a relationship on the date or time fields, just one on a new timestamp field in the Time table (that is a combination of the global date and the time field)

and you'll need new timestamps field in Tasks, one for start and one for end and base the relationship on these.

Thank you it seems to be working fine. By the way how do i calculate the endtimestamp? Right now i am using 3 fields Hours to Complete, Start Timestamp and End Timestamp. I know @comment provided me a calculation for this but i deleted the thread.

Edited February 19, 201610 yr by chadski021

Don't delete threads, even if they are confusing.  There's always something to be learned from it.

You calculate the ending timestamp just like you do for the starting timestamp:

Timestamp ( taskDateEnd ; taskTimeEnd )

 

 

Another thing, Using the calculation is there a way to skip the weekends?

Why not do a search for Weekend Calculations. Here, I’ll give some hints.

Brian Dunning's Custom Functions site Here  I already use a search word of Weekend for you. Do a Google search using these words site:fmforums.com Weekend Calculations

Let me know if you don’t find what you want.

@Lee Smith thanks finally solve my issue.