converting to time format

[Madiya]

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,

 

[alanglloyd]

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

 

[CellShocked]

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.

 

[Madiya]

  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

 

[Pete_UK]

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

 

[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

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.
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.

 

[Pete_UK]

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

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.

- Show quoted text -

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

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 -