Talend community forum / Military time Diff (time calcuation)

midwestdedicated · 2010-04-08 21:27:54

I am trying to figure out how to take to string amounts (military times) and get a difference between them

Begin Time : "08:00"
End Time : "17:15"

and get 9.25 hours out of that...

Been working on it for a while and cannot figure it out. Any ideas?

Thanks,

shong · 2010-04-09 06:15:17

Hello
Parsing the string to Date and get the milliseconds.
expression on tMap:

Code:

((TalendDate.parseDate("HH:mm",row1.endTime).getTime()-TalendDate.parseDate("HH:mm",row1.beginTime).getTime())/3600)/1000d

Best regards
Shong

Uploaded Images

Announcement

Unanswered posts

#1 2010-04-08 21:27:54

Military time Diff (time calcuation)

#2 2010-04-09 06:15:17

Re: Military time Diff (time calcuation)

Code:

Board footer