Problem with converting decimal time to hours and minutes

[Guest]

Hi there - I hope someone can help a novice please!
I've tried searching but don't understand most of the answers so apologies
if this has already been answered

I have a spreadsheet which needs to display working hours per week in both
decimal and in hours and minutes. What I'm doing is taking the decimal result
and converting it to hours and minutes using this formula
=TEXT(G28/24,"h:mm") which works a treat ... unless the hours are more than
24

I'm sure there must be a simple solution - but I'm too simple to figure it
out - please help !

Rob

 

[Bob Phillips]

Use

=TEXT(G28/24,"[h]:mm")

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Roger Govier]

Hi Robert

Try
=TEXT(G28/24,"[h]:mm")

 

[Guest]

Thanks Roger - just the job !

Hi Robert

Try
=TEXT(G28/24,"[h]:mm")

--
Regards
Roger Govier

Hi there - I hope someone can help a novice please!
I've tried searching but don't understand most of the answers so apologies
if this has already been answered

I have a spreadsheet which needs to display working hours per week in both
decimal and in hours and minutes. What I'm doing is taking the decimal
result
and converting it to hours and minutes using this formula
=TEXT(G28/24,"h:mm") which works a treat ... unless the hours are more
than
24

I'm sure there must be a simple solution - but I'm too simple to figure it
out - please help !

Rob

 

[Guest]

Perfect ! Thanks Bob - just for my learning - what is the square bracket
doing in that formula please

Rob

Use

=TEXT(G28/24,"[h]:mm")

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

Hi there - I hope someone can help a novice please!
I've tried searching but don't understand most of the answers so apologies
if this has already been answered

I have a spreadsheet which needs to display working hours per week in both
decimal and in hours and minutes. What I'm doing is taking the decimal
result
and converting it to hours and minutes using this formula
=TEXT(G28/24,"h:mm") which works a treat ... unless the hours are more
than
24

I'm sure there must be a simple solution - but I'm too simple to figure it
out - please help !

Rob

 

[Roger Govier]

Hi Robert

The [ ] around the hours, allows it to roll over past 24, instead of
restarting at 1 when it gets to 25

Using a format of Format>Cells>Number>Custom>[h]:mm does the same thing, as
compared to a format of hh:mm
--
Regards
Roger Govier

Thanks Roger - just the job !

Hi Robert

Try
=TEXT(G28/24,"[h]:mm")

--
Regards
Roger Govier

Hi there - I hope someone can help a novice please!
I've tried searching but don't understand most of the answers so
apologies
if this has already been answered

I have a spreadsheet which needs to display working hours per week in
both
decimal and in hours and minutes. What I'm doing is taking the decimal
result
and converting it to hours and minutes using this formula
=TEXT(G28/24,"h:mm") which works a treat ... unless the hours are more
than
24

I'm sure there must be a simple solution - but I'm too simple to figure
it
out - please help !

Rob

 

[Bob Phillips]

It is telling Excel not to cycle the hours around the day, that is25 doesn't
cycle into 1, etc.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

Perfect ! Thanks Bob - just for my learning - what is the square bracket
doing in that formula please

Rob

Use

=TEXT(G28/24,"[h]:mm")

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

Hi there - I hope someone can help a novice please!
I've tried searching but don't understand most of the answers so
apologies
if this has already been answered

I have a spreadsheet which needs to display working hours per week in
both
decimal and in hours and minutes. What I'm doing is taking the decimal
result
and converting it to hours and minutes using this formula
=TEXT(G28/24,"h:mm") which works a treat ... unless the hours are more
than
24

I'm sure there must be a simple solution - but I'm too simple to figure
it
out - please help !

Rob