[Newbie] time to minutes conversion

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Fabien C. - 30 Mar 2004 20:12 GMT

Hello,

here is my problem : I've got a field that contains a time in the
format hh:mm (by example 01:30) for one hour and a half. I would like
to make a calculation with this (a cost, knowing the price for an
hour) so I need a macro that converts 01:30 in a decimal format (01:30
gives 1,5)... How can I do this... I'm sure there is an internal macro
wich is already implemented... But... I can't find it...

HELP !

thank you,

F.C
___________________________________________________________________
Mesure anti spam : dans mon adresse electronique, remplacer .com par .fr

Reply to this Message

Chip Pearson - 30 Mar 2004 20:21 GMT

Multiply your time value by 24.

Signature

Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

> Hello,
>
[quoted text clipped - 10 lines]
>
> F.C

_________________________________________________________________
__

> Mesure anti spam : dans mon adresse electronique, remplacer .com par .fr

Reply to this Message

JE McGimpsey - 30 Mar 2004 20:25 GMT

XL stores time as fractional days (e.g., 03:00 = 8/24 = 0.125), so to
get hours, multiply by 24

A1: 01:30
A2: =A1 * 24 ==> 1.5

Format A2 as General or another numeric format.

> Hello,
>
[quoted text clipped - 4 lines]
> gives 1,5)... How can I do this... I'm sure there is an internal macro
> wich is already implemented... But... I can't find it...

Reply to this Message

Fabien C. - 31 Mar 2004 20:12 GMT

Thank you guys ! That's all I needed !!!!

F.
___________________________________________________________________
Mesure anti spam : dans mon adresse electronique, remplacer .com par .fr

Reply to this Message