PC Review


Reply
Thread Tools Rate Thread

Changing time format

 
 
doodle302
Guest
Posts: n/a
 
      14th Jan 2010
I'm trying to chage the time format so they can be multiplied by a number

Example: ( 6:30 - 2:45 - 1:30 - 2:15 ) * 3 = total amount due in dollars

The four time are for different days

Thanks for any ideas
 
Reply With Quote
 
 
 
 
מיכאל (מיקי) אבידן
Guest
Posts: n/a
 
      14th Jan 2010
In order to multiply 'Time' by 'Currency' - you should ad a multiplication by
24 as well in the formula and format that(!) cell as 'Currency'.
Micky


"doodle302" wrote:

> I'm trying to chage the time format so they can be multiplied by a number
>
> Example: ( 6:30 - 2:45 - 1:30 - 2:15 ) * 3 = total amount due in dollars
>
> The four time are for different days
>
> Thanks for any ideas

 
Reply With Quote
 
David Biddulph
Guest
Posts: n/a
 
      14th Jan 2010
See the answers to your question in
news:microsoft.public.excel.worksheet.functions yesterday. Please don't
multipost.
--
David Biddulph


"doodle302" <(E-Mail Removed)> wrote in message
news:C6F7A0F2-D85E-4F02-B212-(E-Mail Removed)...
> I'm trying to chage the time format so they can be multiplied by a number
>
> Example: ( 6:30 - 2:45 - 1:30 - 2:15 ) * 3 = total amount due in dollars
>
> The four time are for different days
>
> Thanks for any ideas



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Changing a cells format (Time) =?Utf-8?B?S2VpdGg=?= Microsoft Excel Misc 2 21st Jul 2006 03:51 PM
changing normal number format that appears as a time to time forma =?Utf-8?B?UmljaGFyZCBLYW50ZWNraQ==?= Microsoft Excel Misc 1 14th Sep 2004 12:33 PM
changing time format JT Microsoft Excel Programming 2 17th May 2004 10:23 PM
Changing number format to time format issue Iain Microsoft Access Queries 1 28th Nov 2003 02:49 PM
Time/Date format and changing time to GMT Shaiboy_UK Microsoft ASP .NET 0 19th Oct 2003 12:30 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:51 AM.