Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default convert hours format to decimal or minutes (exp. 1:15:00 = 75 min.

How do I copy and past a help example to a blank spreadsheet pertaining to
the above subject?

I can subtract an end time from a begin time to get hours and minutes
(1:15:00 or 75 minutes).

How do I convert 1:15:00 to 75 minutes?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11,501
Default convert hours format to decimal or minutes (exp. 1:15:00 = 75 min.

A custom format of

[m]

Mike

"hard working andy w" wrote:

How do I copy and past a help example to a blank spreadsheet pertaining to
the above subject?

I can subtract an end time from a begin time to get hours and minutes
(1:15:00 or 75 minutes).

How do I convert 1:15:00 to 75 minutes?

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11,501
Default convert hours format to decimal or minutes (exp. 1:15:00 = 75 min.

Alternatively

=(A1-A2)*24*60

Mike

"hard working andy w" wrote:

How do I copy and past a help example to a blank spreadsheet pertaining to
the above subject?

I can subtract an end time from a begin time to get hours and minutes
(1:15:00 or 75 minutes).

How do I convert 1:15:00 to 75 minutes?

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 21
Default convert hours format to decimal or minutes (exp. 1:15:00 = 75 min.

To convert it to a value:
=MINUTE(A1)+(HOUR(A1)*60)
where A1 is the time.

"hard working andy w" <hard working andy wrote
in message ...
How do I copy and past a help example to a blank spreadsheet pertaining to
the above subject?

I can subtract an end time from a begin time to get hours and minutes
(1:15:00 or 75 minutes).

How do I convert 1:15:00 to 75 minutes?



  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,202
Default convert hours format to decimal or minutes (exp. 1:15:00 = 75 min.

To convert it to a value:
=MINUTE(A1)+(HOUR(A1)*60)
where A1 is the time.


While Mike H's formula (=A1*60*24) would be the quickest method (although I
would change the 60*24 in it to 1440 to save a multiplication), if you
wanted to examine alternate methods, then here is another one to consider
(shorter than yours and one function call less)...

=--TEXT(A1,"[m]")

Rick



  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,268
Default convert hours format to decimal or minutes (exp. 1:15:00 = 75 min.

I think Mike used A1*60*24 since it makes more sense than 1440 or 86400 with
seconds

I mean, since we are working with time values if you convert 55000 seconds
into Excel time values I think =55000/24/60/60 makes more sense than
=55000/86400


--
Regards,

Peo Sjoblom



"Rick Rothstein (MVP - VB)" wrote in
message ...
To convert it to a value:
=MINUTE(A1)+(HOUR(A1)*60)
where A1 is the time.


While Mike H's formula (=A1*60*24) would be the quickest method (although
I would change the 60*24 in it to 1440 to save a multiplication), if you
wanted to examine alternate methods, then here is another one to consider
(shorter than yours and one function call less)...

=--TEXT(A1,"[m]")

Rick



  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,202
Default convert hours format to decimal or minutes (exp. 1:15:00 = 75 min.

I think Mike used A1*60*24 since it makes more sense than 1440 or 86400
with seconds

I mean, since we are working with time values if you convert 55000
seconds into Excel time values I think =55000/24/60/60 makes more sense
than =55000/86400


No, I understand that... I just meant that I would have used 1440 in the
formula and put an explanation in the text telling the OP where the number
came from. Sorry for not being more clear about that.

Rick

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I convert decimal values to hours & minutes in Excel 2000? Bo0ts Excel Discussion (Misc queries) 6 August 3rd 07 12:27 AM
How do I convert hours, minutes, and seconds into decimal format? Programmer Wannabe Excel Worksheet Functions 2 May 13th 07 03:01 AM
Convert Decimal hours and Minutes to minutes please. Steved Excel Worksheet Functions 13 July 5th 06 05:33 AM
Convert degrees at 'Minutes' format. i.e. 43° 22', to Decimal Dan Excel Discussion (Misc queries) 1 April 4th 06 11:09 AM
Convert hours and minutes in time format into fractions of hours.. Akern Excel Worksheet Functions 4 April 21st 05 02:56 PM


All times are GMT +1. The time now is 08:29 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"