locked
Minutes to hh:mm RRS feed

  • Question

  • I have one field in minutes( int) , And I would like to convert it to hh:mm . In the Microsoft Access Report , I got the field divide for 86400, ( [FieldName]/60/60/24) and set the format for hh:nnTongue Tieds. Is there any way I can do that in reporting services?

    Thursday, July 31, 2008 7:26 PM

Answers

  • Hi

     

    Try using this expression

    =IIF(Isnothing(Fields!Minutes.Value), nothing, Format(Fields!Minutes.Value/60,"00") & ":" & Format(Fields!Minutes.Value Mod 60,"00"))

     

    Thanks
    Friday, August 1, 2008 3:57 AM
    Answerer

All replies

  • Hi

     

    Try using this expression

    =IIF(Isnothing(Fields!Minutes.Value), nothing, Format(Fields!Minutes.Value/60,"00") & ":" & Format(Fields!Minutes.Value Mod 60,"00"))

     

    Thanks
    Friday, August 1, 2008 3:57 AM
    Answerer
  • Hello,

    The Below Expression is Used to display in the Format hh:mm

     

    Format(Floor(Fields!minutes.Value/60),"00") & ":" & Format(Fields!minutes.Value mod 60,"00")

     

     

    Hope this helps

    Friday, August 1, 2008 6:11 AM