Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Excel>Me [email protected]>
 
Posts: n/a
Default How can i add times in Excel?

So i have been trying to make a worksheet to calculate my pay with deductions
and everything. But the thing is that my punch machine works in decimals. So
i changed that with a formula =TEXT(A1/24; "h:mm") which works great. But now
i want to add times, but it doesn't seem to work. I have tried =SUM(A1:A6)*24
(as suggested in the excel help) but i found out (well i think) that SUM does
not count TEXT. When i try the same formula with hours i have entered myself,
instead of results entered mathematically, it works. I do not know what do to.
  #3   Report Post  
Harald Staff
 
Posts: n/a
Default

Avoid TEXT. Use sinply
=A1/24
and format the cell as time in the Format Cells menu.

HTH. Best wishes Harald

<Excel skrev i melding
...
So i have been trying to make a worksheet to calculate my pay with

deductions
and everything. But the thing is that my punch machine works in decimals.

So
i changed that with a formula =TEXT(A1/24; "h:mm") which works great. But

now
i want to add times, but it doesn't seem to work. I have tried

=SUM(A1:A6)*24
(as suggested in the excel help) but i found out (well i think) that SUM

does
not count TEXT. When i try the same formula with hours i have entered

myself,
instead of results entered mathematically, it works. I do not know what do

to.


  #4   Report Post  
Excel>Me
 
Posts: n/a
Default

Wow thank you so much it was so simple!

now i only have to multiply this total of hours with my wage. how is that
possible? do i have to turn back my total of hours in decimals?

  #5   Report Post  
Bob Phillips
 
Posts: n/a
Default

=A1*the_rate

or if you have a summed time in say H1, then
=H1*24*the_rate

--

HTH

RP
(remove nothere from the email address if mailing direct)


"ExcelMe" wrote in message
...
Wow thank you so much it was so simple!

now i only have to multiply this total of hours with my wage. how is that
possible? do i have to turn back my total of hours in decimals?





  #6   Report Post  
Excel>Me
 
Posts: n/a
Default

It works!! thank you so much!!

"Bob Phillips" wrote:

=A1*the_rate

or if you have a summed time in say H1, then
=H1*24*the_rate

--

HTH

RP
(remove nothere from the email address if mailing direct)


"ExcelMe" wrote in message
...
Wow thank you so much it was so simple!

now i only have to multiply this total of hours with my wage. how is that
possible? do i have to turn back my total of hours in decimals?




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
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
How do I isolate my Excel server (automation) from other Excel instances? Joseph Geretz Excel Discussion (Misc queries) 5 July 19th 13 03:18 PM
Adding/Averaging Times in Excel JD Excel Discussion (Misc queries) 2 January 5th 05 06:07 PM
VB Automation is Whacking out my Excel Environment Joseph Geretz Excel Discussion (Misc queries) 2 December 29th 04 04:49 PM
Excel aficionado wants to learn Access Hari Excel Discussion (Misc queries) 0 December 3rd 04 07:03 AM


All times are GMT +1. The time now is 03:52 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"