Microsoft Stream Attendee Report uses UTC Event Date/Timestamp

%3CLINGO-SUB%20id%3D%22lingo-sub-1002155%22%20slang%3D%22en-US%22%3EMicrosoft%20Stream%20Attendee%20Report%20uses%20UTC%20Event%20Date%2FTimestamp%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1002155%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EMicrosoft%20Stream%20provides%20an%20Attendee%20Report%2C%20the%20timestamp%20however%20is%20a%20UTC%20Event%20Date%2FTimestamp%20which%20does%20not%20correspond%20correctly%20with%20the%20actual%20time%20of%20the%20event%26nbsp%3B(EST).%26nbsp%3B%26nbsp%3BDoes%20anyone%20know%26nbsp%3Bof%20a%20formula%20for%26nbsp%3Bthat%20exists%20for%20use%20within%20the%20generated%26nbsp%3BExcel%20document%20which%20would%26nbsp%3Bprovide%20the%20correct%20time%20information%3F%26nbsp%3B%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EKind%20regards!%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1003424%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Stream%20Attendee%20Report%20uses%20UTC%20Event%20Date%2FTimestamp%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1003424%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F455314%22%20target%3D%22_blank%22%3E%40VLB_UPMCAFP%3C%2FA%3E%26nbsp%3BThanks%20for%20your%20question!%20Although%20this%20is%20not%20Microsoft%20Stream%20related%2C%20there%20is%20a%20%22NOW%22%20function%20in%20Excel%20that%20should%20work%20for%20you%20to%20convert%20time%20zones.%20Since%20the%20time%20zone%20offset%20is%20five%20hours%2C%20you%20can%20try%20this%20function%20and%20see%20if%20it%20works%20for%20you.%20Note%20the%20denominator%20can%20be%20changed%20to%20tweak%20the%20hour%20offset.%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3E%3DNOW()%2B5%2F24%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1030226%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Stream%20Attendee%20Report%20uses%20UTC%20Event%20Date%2FTimestamp%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1030226%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F268540%22%20target%3D%22_blank%22%3E%40NealM%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20you%20shared%20to%20use%20the%20formula%20%3CSTRONG%3E%3DNOW()%2B5%2F24%2C%20was%20this%20within%20the%20same%20cell%20with%20the%20information%20or%20a%20separate%20cell%3F%26nbsp%3B%20I'm%20wondering%20if%20it%20isn't%20working%20because%20there%20is%20not%20only%20the%20time%2C%20but%20a%20date%20timestamp.%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Microsoft Stream provides an Attendee Report, the timestamp however is a UTC Event Date/Timestamp which does not correspond correctly with the actual time of the event (EST).  Does anyone know of a formula for that exists for use within the generated Excel document which would provide the correct time information? 

Kind regards!

2 Replies

@VLB_UPMCAFP Thanks for your question! Although this is not Microsoft Stream related, there is a "NOW" function in Excel that should work for you to convert time zones. Since the time zone offset is five hours, you can try this function and see if it works for you. Note the denominator can be changed to tweak the hour offset.

=NOW()+5/24

@NealM 

 

When you shared to use the formula =NOW()+5/24, was this within the same cell with the information or a separate cell?  I'm wondering if it isn't working because there is not only the time, but a date timestamp.