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

Use

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

--
---
HTH

Bob

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



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

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

Rob

"Bob Phillips" wrote:

Use

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

--
---
HTH

Bob

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



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

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)



"RobertSE6" wrote in message
...
Perfect ! Thanks Bob - just for my learning - what is the square bracket
doing in that formula please

Rob

"Bob Phillips" wrote:

Use

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

--
---
HTH

Bob

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



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

Hi Robert

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

--
Regards
Roger Govier



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

Thanks Roger - just the job !

"Roger Govier" wrote:

Hi Robert

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

--
Regards
Roger Govier



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

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 FormatCellsNumberCustom[h]:mm does the same thing, as
compared to a format of hh:mm
--
Regards
Roger Govier



"RobertSE6" wrote in message
...
Thanks Roger - just the job !

"Roger Govier" wrote:

Hi Robert

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

--
Regards
Roger Govier



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