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

"bhanupriya" wrote in message ...
|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
|

=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

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

"Teethless mama" wrote in message
...
| =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
|