Remember Me?

#1
November 15th 04, 07:09 PM
 Todd Posts: n/a
convert 100 minute hour to a 60 minute hour

I have a spreadsheet that calculates time on a project. The time is input
using 100 minute hours and totals up that way. I need to convert the total
to a 60 minute hour. So 48.50 would become 48.30. I am having trouble
thinking of how to do this. I don't know how get a formula to convert only
the minutes. Can anyone help?

Todd

#2
November 15th 04, 07:14 PM
 Frank Kabel Posts: n/a

Hi
try:
=A1/24
and format with the time format
[hh]:mm

--
Regards
Frank Kabel
Frankfurt, Germany

"Todd" schrieb im Newsbeitrag
...
I have a spreadsheet that calculates time on a project. The time is

input
using 100 minute hours and totals up that way. I need to convert the

total
to a 60 minute hour. So 48.50 would become 48.30. I am having

trouble
thinking of how to do this. I don't know how get a formula to

convert only
the minutes. Can anyone help?

Todd

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Ian Excel Discussion (Misc queries) 1 December 15th 04 10:58 PM

All times are GMT +1. The time now is 12:39 PM.