I need a help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am not able to change the cell to h:mm, and i want them to add also.
my format is in such a way

Incoming 9.50 9.30 9.15 9.00 9.30 9.40
Lunch 0.40 0.40 0.40 1.00 0.30 -
Outgoing 6.20 5.50 5.45 5.35 6.00 1.30

i want to have total working hrs.
pls help me
 
=VALUE(SUBSTITUTE(TEXT(A1,"0.00"),".",":"))
Format as Time

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I am not able to change the cell to h:mm, and i want them to add also.
| my format is in such a way
|
| Incoming 9.50 9.30 9.15 9.00 9.30 9.40
| Lunch 0.40 0.40 0.40 1.00 0.30 -
| Outgoing 6.20 5.50 5.45 5.35 6.00 1.30
|
| i want to have total working hrs.
| pls help me
|
 
Possibly. But that would turn 9.50 into 09:30, not 09:50.
So it depends on what the OP means with 9.50.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| =A1/24
|
| format cell as h:mm
|
|
| "bhanupriya" wrote:
|
| > I am not able to change the cell to h:mm, and i want them to add also.
| > my format is in such a way
| >
| > Incoming 9.50 9.30 9.15 9.00 9.30 9.40
| > Lunch 0.40 0.40 0.40 1.00 0.30 -
| > Outgoing 6.20 5.50 5.45 5.35 6.00 1.30
| >
| > i want to have total working hrs.
| > pls help me
| >
 
Back
Top