From: ijustlivehere on
What if I go over midnight?

"Peo Sjoblom" wrote:

> Multiply by 24 and format as general or number
>
>
> =A2*24
>
>
>
> --
>
>
> Regards,
>
>
> Peo Sjoblom
>
> "3Nails" <3Nails(a)discussions.microsoft.com> wrote in message
> news:8902FC93-C724-4E4A-8DF3-47331D51EB90(a)microsoft.com...
> > Calculated hours and mintues from time;
> >
> > 16:00 (4PM) to 19:30 (7:30PM) is 3:30.
> >
> > How can I convert the results 3 hours and 30 minutes to 3.5 hours?
>
>
>
From: Fred Smith on
See your other post.

Regards,
Fred

"ijustlivehere" <ijustlivehere(a)discussions.microsoft.com> wrote in message
news:7FA2471B-10AD-4F66-B0A3-334CFA2A0EDC(a)microsoft.com...
> What if I go over midnight?
>
> "Peo Sjoblom" wrote:
>
>> Multiply by 24 and format as general or number
>>
>>
>> =A2*24
>>
>>
>>
>> --
>>
>>
>> Regards,
>>
>>
>> Peo Sjoblom
>>
>> "3Nails" <3Nails(a)discussions.microsoft.com> wrote in message
>> news:8902FC93-C724-4E4A-8DF3-47331D51EB90(a)microsoft.com...
>> > Calculated hours and mintues from time;
>> >
>> > 16:00 (4PM) to 19:30 (7:30PM) is 3:30.
>> >
>> > How can I convert the results 3 hours and 30 minutes to 3.5 hours?
>>
>>
>>

 | 
Pages: 1
Prev: IF ERROR FORMULA
Next: Converting Hours to Decimal