Challenge #68: Elapsed Classroom Times

[SidSaythongphet]

Spoiler

 

[alfredcsy]

[asultanov]

Solution attached.

[Inactive User]

#solution 68

[SanjeevDosanjh]

Spoiler

 

[LorraineF]

Practicing the date tool

[a640687]

Spoiler

Inside the formula tool:

Spoiler

[hpt]

Here's my solution. This challenge is a difficult time for me. As I'm not efficient with tools and configurations yet, the formulas I wrote are long and error prone.

[Sivashankaran]

Hi Everyone, 

Attaching the solution file for Challenge #68

1. Created Begin_Date and End_Date column using below formula,

if([MILITARY BEGIN_TIME] = 'TBA'

or [MILITARY BEGIN_TIME] = ''

or [MILITARY BEGIN_TIME] = Null()) THEN

Replace([MILITARY BEGIN_TIME], Null(), '')

ELSEIF (Length([MILITARY BEGIN_TIME]) = 3 )

THEN

[START_DATE]

+' 0'

+ Substring([MILITARY BEGIN_TIME],0,1)

+":"

+ Substring([MILITARY BEGIN_TIME],1)

ELSE

[START_DATE]

+" "

+Substring([MILITARY BEGIN_TIME],0,2)

+ ":"

+Substring([MILITARY BEGIN_TIME],2)

ENDIF

2. Use below formula to Calculate Elapsed Time

DateTimeDiff([End_Date],[Begin_Date],'minutes')

3. To met objectives used Below­ format formula to display Begin Time and End Time appropriately.

Feedbacks open!

Thanks,

Siva

[MMC15]

Spoiler