Convert decimal hours into HH:ii:ss greater than 24 hours

Question

I have a decimal value (64.17 hours) and need to convert this to a timestamp of hours, minutes and seconds but the hours value should show 64 not 16.

It should also not show the microseconds so 64.17 would be displayed as

64:10:12

Anyone help me on this? I also need to put it in an aggregate function (average in this case)

TimeSpan ts = new TimeSpan();
            ts.Add(TimeSpan.FromHours(ncr_time_lost));
            Console.WriteLine(ncr_time_lost + " = " + TimeSpan.FromHours(ncr_time_lost).ToString());

            return TimeSpan.FromHours(ncr_time_lost);

[Standard TimeSpan Format Strings](http://msdn.microsoft.com/en-us/library/ee372286.aspx) & [Custom TimeSpan Format Strings](http://msdn.microsoft.com/en-us/library/ee372287.aspx) — dtb, Feb 07 '12 at 16:58

score 4 · Answer 1 · edited May 23 '17 at 11:56

4

Why not just use the TimeSpan structure? Yes it keeps track of days, but there's also a TotalHours property that should give you everything your looking for.

You can also do any averaging calculations on the TotalMilliseconds property.

See here for more information on formatting the TimeSpan.

edited May 23 '17 at 11:56

Community

1
1

answered Feb 07 '12 at 17:03

rie819

1,249
12
19

My issue is formatting it within the report which keeps coming back as an error! I have in the class a timespan created using the code I just added to the question but when I show it on the report it comes back with #Error – Neo Feb 08 '12 at 09:46

score 2 · Accepted Answer · edited Feb 08 '12 at 11:27

2

Update Working Code Add the below to the code part for the report

Public Function TimeSpanToString(source as Timespan) as String
    Dim result As String
    result = Convert.ToInt32(source.TotalHours).ToString() & ":" & source.Minutes.ToString() & ":" & source.Seconds

    return result
End Function

Here is the answer with an example: TimeSpan.FromHours Method.

Update: The format "64:10:12" can be done with the following code:

static string TimeSpanToString(TimeSpan source)
{
    string result = string.Format("{0}:{1}:{2}",
        (int)source.TotalHours,
        source.Minutes,
        source.Seconds);
    return result;
}

Update: Don't know whether it's correct, but try the following to use it from RDLC:

public class SomeClass
{
    public TimeSpan Time { get; set; }

    public string FormattedTime
    {
       get { return TimeSpanToString(Time); }
    }

    private static string TimeSpanToString(TimeSpan source)
    {
        // Code.
    }
}

Then try to get it from the report as "=Fields!FormattedDate.Value".

edited Feb 08 '12 at 11:27

Ross

46,186
39
120
173

answered Feb 07 '12 at 17:09

Sergey Vyacheslavovich Brunov

17,291
7
48
81

How would this be used in a report? – Neo Feb 08 '12 at 09:44
Thanks Serge I'm new to RDLC do I just put this in the report code and call it? If so it comes back with a custom code error – Neo Feb 08 '12 at 10:21
@Neo, actually, I've not tested the code with RDLC, just a sketch (see the post update). – Sergey Vyacheslavovich Brunov Feb 08 '12 at 10:33
Thanks Serge, Your answer pointed me in the right direction, it appears the RDLC code is VB :( I've added the working code to your post and marked it as the right answer – Neo Feb 08 '12 at 11:17

Convert decimal hours into HH:ii:ss greater than 24 hours

2 Answers2