i'm trying spreadsheet in numbers keep track of hours work , need formula, can't figure out. need
column 1 date
column 2 time started e.g 0600
column 3 time end e.g. 1300
column total hours e.g.7:00
need column put in how many hours i've been paid , how still owed.
thank in advance received.
dates , times in numbers can tricky, , seems way more complicated needs be, considering how easy want claris/appleworks.
work:
=time end -time started
you'll run trouble if ever go , edit time, because numbers stores current date inside time record. if today time started @ 6 a.m. , ended @ 1 p.m., decide go tomorrow change 1:30, you're 31 1/2 hours.
here's do:
=24*(timevalue(time end)-timevalue(time started))
cell format inspector figures out want. lots of time doesn't. here, you'd want format cell number offering number decimal places need. it's number (not date value) , should able add whatever columns need enter number of hours you've been paid , calculate number of hours still need payment for.
mt
Forums Macs Mac Apps and Mac App Store
- iPhone
- Mac OS & System Software
- iPad
- Apple Watch
- Notebooks
- iTunes
- Apple ID
- iCloud
- Desktop Computers
- Apple Music
- Professional Applications
- iPod
- iWork
- Apple TV
- iLife
- Wireless
Comments
Post a Comment