|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
April 5th, 2010, 11:04 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
Time calc formula please.
Can you please tell me what the formula for this is please. A1 (start time) 0800 A2 (end time) 1515 A5 (total hrs=) 7.25 I need the formula for A5 TIA 
|
|
#2
April 5th, 2010, 11:16 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Time calc formula please.
=24*(TEXT(A2,"00\:00")-TEXT(A1,"00\:00"))
It would have been easier if you had put in your times as times, 08:00 and 15:15 -- David Biddulph "Mario" wrote in message ... Can you please tell me what the formula for this is please. A1 (start time) 0800 A2 (end time) 1515 A5 (total hrs=) 7.25 I need the formula for A5 TIA
|
|
#3
April 5th, 2010, 11:49 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Time calc formula please.
Hi,
Put this in A5 and format as general =(A2-A1)*24 -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Mario" wrote: Can you please tell me what the formula for this is please. A1 (start time) 0800 A2 (end time) 1515 A5 (total hrs=) 7.25 I need the formula for A5 TIA .
|
|
#4
April 5th, 2010, 11:57 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Time calc formula please.
That's fine if the contents of A2 and A1 are times formatted without the
colon, but they look as though they might be text. -- David Biddulph "Mike H" wrote in message ... Hi, Put this in A5 and format as general =(A2-A1)*24 -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Mario" wrote: Can you please tell me what the formula for this is please. A1 (start time) 0800 A2 (end time) 1515 A5 (total hrs=) 7.25 I need the formula for A5 TIA .
|
|
#5
April 5th, 2010, 12:34 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Time calc formula please.
David,
I never noticed that until I saw your other post, I agree my solution is unlikely to be the answer. -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "David Biddulph" wrote: That's fine if the contents of A2 and A1 are times formatted without the colon, but they look as though they might be text. -- David Biddulph "Mike H" wrote in message ... Hi, Put this in A5 and format as general =(A2-A1)*24 -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Mario" wrote: Can you please tell me what the formula for this is please. A1 (start time) 0800 A2 (end time) 1515 A5 (total hrs=) 7.25 I need the formula for A5 TIA . .
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
