I have in cell B2 10.50 which excel shows as 10.5 in "general format"
I need to have the same in time format which hh:mm
Pl help me with formula.
I tried left and right functions but not getting anywhere.

I also need to get the time differance in hh:mm format.
Pl advise me.

Regards,

On Aug 5, 7:29*am, Madiya <madiya...@yahoo.co.uk> wrote:
> I have in cell B2 10.50 which excel shows as 10.5 in "general format"
> I need to have the same in time format which hh:mm
> Pl help me with formula.
> I tried left and right functions but not getting anywhere.
>
> I also need to get the time differance in hh:mm format.
> Pl advise me.

Right-Click on cell, choose Format Cells | Number | Custom. Choose
hh:mm & OK

Open Excel Help

Choose Contents > Formatting Worksheets > Formatting Numbers Dates and
Times > Custom Number Date & Time Format Codes > Format Date & Times.

Read, digest & understand.

Alan Lloyd

On Thu, 5 Aug 2010 00:37:55 -0700 (PDT), "(E-Mail Removed)"
<(E-Mail Removed)> wrote:

>On Aug 5, 7:29*am, Madiya <madiya...@yahoo.co.uk> wrote:
>> I have in cell B2 10.50 which excel shows as 10.5 in "general format"
>> I need to have the same in time format which hh:mm
>> Pl help me with formula.
>> I tried left and right functions but not getting anywhere.
>>
>> I also need to get the time differance in hh:mm format.
>> Pl advise me.
>
>Right-Click on cell, choose Format Cells | Number | Custom. Choose
>hh:mm & OK
>
>Open Excel Help
>
>Choose Contents > Formatting Worksheets > Formatting Numbers Dates and
>Times > Custom Number Date & Time Format Codes > Format Date & Times.
>
>Read, digest & understand.
>
>Alan Lloyd


10.5 then becomes what 10 and one half hours or 10 hours, 50 minutes?

The person needs to combine the values correctly, so we need more
information as to what the numbering refers to

10.5 hours or 10 hours 50 minutes, THEN we can perform work in another
cell to get the desired result.

Read, digest, and understand?

Dude, you lost something way back before you started using that stupid
sign off. First off, it is clearly a veiled insult. Good job, idiot.

On Aug 5, 6:34*pm, CellShocked
<cellshoc...@thecellvalueattheendofthespreadsheet.org> wrote:
> On Thu, 5 Aug 2010 00:37:55 -0700 (PDT), "alangll...@aol.com"
>
>
>
>
>
> <alangll...@aol.com> wrote:
> >On Aug 5, 7:29*am, Madiya <madiya...@yahoo.co.uk> wrote:
> >> I have in cell B2 10.50 which excel shows as 10.5 in "general format"
> >> I need to have the same in time format which hh:mm
> >> Pl help me with formula.
> >> I tried left and right functions but not getting anywhere.
>
> >> I also need to get the time differance in hh:mm format.
> >> Pl advise me.
>
> >Right-Click on cell, choose Format Cells | Number | Custom. Choose
> >hh:mm & OK
>
> >Open Excel Help
>
> >Choose Contents > Formatting Worksheets > Formatting Numbers Dates and
> >Times > Custom Number Date & Time Format Codes > Format Date & Times.
>
> >Read, digest & understand.
>
> >Alan Lloyd
>
> * 10.5 then becomes what 10 and one half hours or 10 hours, 50 minutes?
>
> * The person needs to combine the values correctly, so we need more
> information as to what the numbering refers to
>
> *10.5 hours or 10 hours 50 minutes, THEN we can perform work in another
> cell to get the desired result.
>
> * Read, digest, and understand?
>
> * Dude, you lost something way back before you started using that stupid
> sign off. *First off, it is clearly a veiled insult. *Good job, idiot..- Hide quoted text -
>
> - Show quoted text -

Thank you CellShocked for your reply.

10.5 is 10 hours 50 minutes
13.2 is 13hrs 20 mins.

Hope this can be acheived by a formula.

Regards.
Madiya

Try this in C2:

=--(INT(B2)&":"&INT(MOD(B2,1)*100)&":00))

Format the cell as a date in an appropriate style (eg [hh]:mm).

In your first post you asked about time difference - which two cells
would contain the times?

Hope this helps.

Pete

On Aug 6, 11:04*am, Madiya <madiya...@yahoo.co.uk> wrote:
>
> Thank you CellShocked for your reply.
>
> 10.5 is 10 hours 50 minutes
> 13.2 is 13hrs 20 mins.
>
> Hope this can be acheived by a formula.
>
> Regards.
> Madiya

On Aug 6, 6:28*pm, Pete_UK <pashu...@auditel.net> wrote:
> Try this in C2:
>
> =--(INT(B2)&":"&INT(MOD(B2,1)*100)&":00))
>
> Format the cell as a date in an appropriate style (eg [hh]:mm).
>
> In your first post you asked about time difference - which two cells
> would contain the times?
>
> Hope this helps.
>
> Pete
>
> On Aug 6, 11:04*am, Madiya <madiya...@yahoo.co.uk> wrote:
>
>
>
>
>
> > Thank you CellShocked for your reply.
>
> > 10.5 is 10 hours 50 minutes
> > 13.2 is 13hrs 20 mins.
>
> > Hope this can be acheived by a formula.
>
> > Regards.
> > Madiya- Hide quoted text -
>
> - Show quoted text -

Thanks for the help.
I am getting error in the formula and excel dont allow me to the enter
the same.

>>> time difference - which two cells would contain the times?
Both the cells will have same formula you have provided me (some
correction reqd)
1st cell is c2 2nd cell will be g2

Regards,
Madiya.

Sorry, I can see that I missed a " from the end of that formula and
had a ) instead. Replace it with this:

=--(INT(B2)&":"&INT(MOD(B2,1)*100)&":00")

Once you have the formula working for the two times, you can just
subtract them.

Hope this helps.

Pete

On Aug 13, 8:13*am, Madiya <madiya...@yahoo.co.uk> wrote:
> On Aug 6, 6:28*pm, Pete_UK <pashu...@auditel.net> wrote:
>
>
>
>
>
> > Try this in C2:
>
> > =--(INT(B2)&":"&INT(MOD(B2,1)*100)&":00))
>
> > Format the cell as a date in an appropriate style (eg [hh]:mm).
>
> > In your first post you asked about time difference - which two cells
> > would contain the times?
>
> > Hope this helps.
>
> > Pete
>
> > On Aug 6, 11:04*am, Madiya <madiya...@yahoo.co.uk> wrote:
>
> > > Thank you CellShocked for your reply.
>
> > > 10.5 is 10 hours 50 minutes
> > > 13.2 is 13hrs 20 mins.
>
> > > Hope this can be acheived by a formula.
>
> > > Regards.
> > > Madiya- Hide quoted text -
>
> > - Show quoted text -
>
> Thanks for the help.
> I am getting error in the formula and excel dont allow me to the enter
> the same.
>
> >>> time difference - which two cells would contain the times?
>
> Both the cells will have same formula you have provided me (some
> correction reqd)
> 1st cell is c2 2nd cell will be g2
>
> Regards,
> Madiya.- Hide quoted text -
>
> - Show quoted text -